And also, Eli was absolutely the best character. Rush was pretty good, too, but didn’t get developed as much, and was kind of a jerk. And then Greer was also pretty neat.
define “best” 
(now i am going a bit offtopic)
i think it’s a quite different character, and of course eli appealed to me aswell, since he is supposed to be the character you identify with: young gamer, full of ideas and potential, gets beamed up to the spaceship by a funny general and suddenly finds himself in a galactic adventure. also his love story was quite impressive and also quite dramatic in its own way.
however, dr. rush appealed way more to me, since his role is deeply intellectual, deeply emotional, and very good writing and acting - he is the cold science, who actually makes a lot of sense, and sometimes you can see that he actually has a big heart, but does not want the opportunity wasted to solve the mystery of the gateship.
having lost his wife, rush seems to be reduced to cold logic and science at times, but exactly the portrayal of this deeply torn character needed a very impressive piece of acting, and the fact, that you kind of “hate” the character at times, is just a result of that.
Greer is of course yet another well played character, indeed. And by far one of the most entertaining ones. Even the Colonel, who turns out to be quite corrupt in his own way, is in fact a great character, and some of the plot twists with the Lucian Alliance were awesome conclusions of the other SG series.
So it’s really not the characters, or the idea itself, basicly, SGU was missing a greater *new* plot arc, and was focusing too much on the characters and the SG background story at times. Which made it look like a C.S. Lewis sci-fi story, with great morale questioning characters, great visions of scifi, but little entertainment value; a hard to read book that tells a very intellectual story with beautiful pictures, but sometimes misses to actually keep it interesting to appeal to everyone.
This made SGU sometimes almost the opposite of what the rest of the franchise was: not taking yourself seriously, funny lines while portraying murrican heroes, trying to avoid senseless tech talk, and coming up with rather good villains, like Ba’al, Yu, Adria. Even Atlantis did that one right.
It was definitely canceled before it could reach its full potential, without question. But maybe it could have needed a couple more epic space battles, like entering a galaxy where some alien factions were at some giant war; they could have taken a look at Star Treks “Voyager” for that part, which is in fact a very similar storytelling, but way better; even if SGU was way more dark, serious and could have been awesome at some point.
So, yeah, Voyager is also quite nice btw. at least Species 8472 vs. the Borg story arc e.g. has some really nice space battles in it.
Every time I watched that series again, at least, I was like “Oh yeah, now they enter borg space, prepare to be assimilated!” - voyager clearly did its part to define that alien race, which is one of the big intuitive and original ones of the st universe.
Wing commander is not that bad really. Ok, the acting and the script are just awful, but the CGI and the battles are fun to watch.
you just kinda made me wanna see that one. i played the games, but never wanted to see the movie…