I switched over to D* the middle of last week. I have a SD 55" big screen and the quality is very clear and crisp, almost like watching a DVD on everything. I will admit the locals are less crisp, but not bad by any means.
In my comparison of PQ, I have had the following services:
1. Cox Cable Oklahoma
2. E*
3. D*
No doubt about it, the locals look best with Cox. Mainly because they broadcast in HD and are simply beautiful. Even though my SD set cannot take full advantage of the broadcast, it does look very awesome. Put the locals aside, and it's hit and miss. The digitals look nice, the analogs look like crap.
In regards to E*, I'm not sure when you last had their service but based on my last experience with them just January of this year, right before the big Rose Bowl game between USC & Texas I might add, I must say they suck royally. I was looking very forward to the game on the satellite feed, and was vastly disappointed. The compression was so horrible that most the time, I could not see the football in the air when it was thrown. Mind you, this was on my 55" SDTV, so I tried the 27" SD set in my bedroom. It's the same, just a smaller version. After numerous service calls to my house, and the fight of my life I was *finally* able to get out of my contract.
Just FYI, I had E* about 3 years back and the quality was good. I would have stayed but customer service was jerking me around when I moved to a new house. Now IMO, they not only have bad customer service but also bad PQ.
I'd gladly take Cox cable over E* anyday. Luckily I found D* to be 100x better than either of the 2 previous services, plus it is alot cheaper.