I liked the Duncan character for a couple of reasons. Paul was much more believable as a 400 year old warrior and in the series format we got so much more depth and history to enjoy. The first movie was the only good one in the whole five attempts. I will say at least #5 brought the Duncan story a decent finish. The series did suffer from a major fault also found in the movies. They had a cool concept that for some reason the movies 2-5 just could not help changing in really catastrophic ways. Even the series started suffering from that at times.
The writing in both areas just did not equal the potential of the subject matter. The movies suffered the most from those problems but the series had problems as well. All said and done though I did like the show and first movie with a soft spot for The Source just because it gave a conclusion for Duncan. I guess the reboot is stuck in limbo but I am sure if gets made it will be as Connor but they should use Duncan as a template.
The reboot is to feature Connor , last I read.
As to the Source, all involved with that abomination agree that it never happened.