I enjoyed SGU as well. Watched pretty much all of the previous series as well, and SGU was by far the least "campy". The episode that started out with the Flogging Molly track hit the nail on the head ... a bunch of unprepared people in a REALLY bad situation, each struggling with their own personal demons just to make it to the next "worst day since yesterday."
I will be sad to see it go, feeling that it was (by far) the best thing SciFi had going for it. I guess now they can concentrate on more wrestling shows... *sigh*