I remember when in Dec. '05 I had my first HD connection completed, to a 40" Sony LCD TV. The tech tuned-in the "Demonstration" channel from 61.5 (the aquarium scenes) while the rest of the programming was being activated, and I almost cried it looked so damn good...!
Unfortunately not everything looks as good, at the same overall PQ. And "HD" is quite variable, in part due to the quality of the programming but mostly due to the BW allocations. If you have local OTA channels, by all means get them into your system as well. I still consider my local OTA PBS station as my TV HD benchmark. Nothing available over the DBS services at this time can equal that. Of course, HD DVD/BD can beat all b'cst/DBS quality! So keep expanding your horizons! You'll get "used" to HD (especially "HD lite") quickly so the >> wow! << factor doesn't last. But every time you tune between SD and HD, you'll be glad you made the upgrade, and will wonder why you waited so long...!
Enjoy !!
Welcome, BTW...!