ORIGINAL: feygan
Whilst I love SG1 and the almost all the SG universe it does suffer from the same disease almost all sci-fi shows suffer from. It went on too long and had no clue where it was going, made new seasons just for the dollars.
All time favourite is B5 (although a couple of the movies were a little poor,) and it's so great because it had a defined story, someone with more than half a brain cell came up with real characters, and realistic events they care about. This meant you cared about the characters too, it also meant when you got to the end it didn't feel like just the next cliff hanger "oh I wonder if it's renewed for season XXXVII." Just a pity they dangled the carrot and got him to go ahead with crusade, the last B5 ep felt like the last chapter of any great novel, you still talked about it after reading but you always felt content the story was ended.
As for films someone mentioned "Moon" great film that shocked the hell out of me in the current market of "no plot fill with extra cgi" that comes out. Few others:
Dark City
Dune/Children of Dune (sci-fi tv versions only)
Mars Attacks (so many folk get their head vaporized its just unreal)
Monsters (think cloverfield with an actual plot)
Pitch black/Chronicles of Riddick
Splice (Species on acid)
Sunshine (still will argue with anyone to say its not amazing in everyway)
The Abyss
The Black Hole
The Fountain (up there with Sunshine)
Total Recall
Missed Sunshine & The Fountain & Children of Dune!
Thanks!