For desktop use, I prefer LCD hands down. But only in the panel's native res, which is somewhat limiting using old Zorro gfx boards. I have an older Eizo L367 LCD I use with a 1024x768 screenmode from the PIV. It's small, but absolutely crystal clear - *very* high quality picture for a 15". (Partial credit goes to the incredibly sweet analog signal from the Picasso.) Games look decent enough as well, noticable ghosting but the colors are nice and bright. Of course large LCDs can look great, too.
I still think a quality CRT is king for Amiga gaming, but only under certain conditions, and often with a lot of expense and fussing. I have a few nice ones I keep around, hopefully they last a long time.