I guess it really depends on what you'll be using your Amiga for the MOST. For me, I use it for Workbench (internet, graphics apps, everything) and so I prefer a display that can show the resolution I want to display natively, and that's 1024x768. I have an LCD monitor but the native resolution is 1280x1024 and pretty much everything looks {bleep} on it. Games are alright... except they're NOT scaled proportionately as I would have wanted (320x256 x4 = 1280x1024) and it still has black bars along the sides of the screen, about 1cm wide each. So I've resorted to using a CRT, which displays every mode beautifully with no ugly interpolation as you'd get from an LCD. I would prefer to be running an LCD monitor because of my eyes and the energy efficiency, but until the HighGFX Extreme 1280x1024 driver comes out, or if I get another LCD, I'll stick to this CRT.
Your idea of finding an LCD with a native resolution of 1024x768 is one I've been thinking about recently. I'd be able to run this ideal resoultion natively, but I'm not sure how good games and other PAL resolutions would look. In fact I think the best idea would be to go for an LCD TV that has VGA as well as S-Video and other inputs. This way you can use it as your main Amiga/Indivision monitor, and you could also get one of those little portable media players, the ones with the hard drive inside and they connect to a TV and play all your videos, mp3s, jpegs and other downloadable media. Some of these even have CF readers in them, and they all have USB. So they can easily be used with an A1200 with a Subway USB card to download all your videos to, and play on the same monitor as your Amiga (you'd just have to press the input button to switch between the A1200 and media drive). Of course, the CF ones are useful for A1200 owners who don't have USB, but want to download videos to play on their monitor, just copy via Compact Flash card.
Okay sorry for going off-topic, but there are a lot of things to consider when choosing the right monitor. Personally I can't wait to try my idea of an LCD TV with a media drive plugged into the A1200. Downloading movies from torrents and other P2P networks via AmiGift and then playing them full screen with no skipping, and not even needing a graphics card or a PPC. Yeah, that'd be sweet.