I have one LCD and 2 DLP's. I got a small, cheap, BENQ 26" LCD for the bedroom without expecting too much in terms of quality but have been very pleasantly surprised. Bright and clear on HD, and even pretty good on digital OTA SD. I don't have any analog OTA, so I can't comment on that. I didn't even connect the built-in tuner to an antenna. E* SD looks crappy, but that's true on everything bigger than about 2.5" anyway.
The area where DLP's look consistently better is on dark scenes. The LCD blacks look pretty good with full room lighting, but when you lower the room light the inability of an LCD to go truly black makes the picture look somewhat washed out. Nothing beats a good CRT for greyscale, but the DLP's I've seen seem to do a better job than any of the LCD's I've seen so far. Of course LCD's don't have "rainbows" that drive some people crazy with DLP's. (Fortunately I can't see rainbows, even when I'm trying really hard to look for them.)
Bob