LCD tech probably fits 99% of the users out there. Office work does not require multiple resolutions and low input lag. I've seen some serious design work done on a TN panel (sure, not the cheapest one, but still TN). I've been holding to my CRT as a primary display until 2006 IIRC, but I found it much more tiresome to work on as opposed to an LCD. And I had high quality BNC cables (much crispier than a VGA cable) and 85Hz refresh (which seemed to be the sweet spot between crisp image and no flickering)...I noticed I was really tired after a few hours, while I was much more productive on my laptop at the time.
My 5 year old HD4850 can run newest games at 1920x1200, not with all the details and not with 100+fps, but good enough for me that I hadn't felt the need to upgrade yet. A high quality TV can really produce a stunning image if the source is OK and while I probably still watch more than 50% of the non-HD PAL content, the upscale is ok if you don't have a cheap china noname LED TV (I don't like Sony as a company that much, but in my experience they produce the best damn TVs you can get, worth every cent).
In all, I feel that even with a few shortcomings, the tech is a step forward. Sure, there are some stupid marketing decisions that drive the development and deliver a sub-standard product but hopefully an informed buyer will have an opportunity to buy a good product. As one of the biggest shortcomings - only 1 native res - this is really a problem only until the native resolution is high enough. Have a 16K (when did we switch from measuring vertical resolution [720p, 1080p] to horizontal [4K]?) or some other insanely high DPI display and the pixel size is small enough for the resample not to be noticeable.