For those of you interested, the series finale is <a href='http://www.youtube.com/watch?v=MmBVQ1fidlA' target='_blank' rel='nofollow'>Here.</a> I am very pleased. Though without context, the scene does seem a bit unusual. It's not something you could watch out of context like certain scenes from other shows and movies involving Superman saving the day.
As to my thoughts about Smallville in general: It was pretty good. It definitely stumbled in the fifth and some of the sixth seasons, but in general I couldn't be more pleased with a live-action superhero tv show. My only major problem with it is that Clark already defeated most of his major enemies from the comics, so I don't know who would be a good villain later on. Also, many of his actions and some of his personality, even now, aren't very conductive to being Superman. Finally, he looks odd in his Superman outfit. But that could just be because I'm so used to seeing Tom Welling in regular clothes.