Recall that almost all HD through both sat. providers is really "HD Lite", but the PQ is still decent and improving. This is not to be a discussion on HD vs. the lower quality renditions however - plenty of other threads on that!
I have the lowest HD package - HDBronze - and that one still gets me 27 HD channels, IIRC. I for one like a lot of the content on the 15 voOm channels, particularly FilmFest, MonstersHD, Rave, Worldsport, and yes even UltraHD. There's very little in real-time sports on the national HD channels and voOm however. ESPN and ESPN2 are about it. Not all channels are 24/7 HD, but the voOm channels are. One complaint with voOm is that it's repetitive, but I actually like that - many opportunities to see everything once. A&E HD is a mixed bag. I don't watch it much. Most of what I have seen is really SD. Some of the programming is in 1080i, but the "other" resolution number is also important as is the bitrate. MPEG-4 is going a long way toward improving the HD experience!
I have an 811 and a 622. Both are mediocre on the SD channels, but that is as much a limitation of watching on a large screen TV as it is a comment on the receivers' capabilities. I don't watch much SD on my big screen TV so I don't have that complaint, but it is real. Some folks get better results on SD by using one of the composite outputs so you might want to try that.
That's my 2-cents worth. To me it's worth it, even tho' I only get to watch only 6-10 hours of HD a week. As always, YMMV...