My LCD does not ghost at all (Samsung 151MP) and I play video on it quite a bit (Composite input and HD input.) I don't use a TV Tuner card in it though, maybe that's what you have heard about ghosting? A properly connected input should not ghost, but a TV signal from a weak antenna signal or bad cable TV channel might ghost, just like it would on your living room TV. But plugging your game boxes in to one should not ghost it at all.
Go to your local electronics dealer and tell them you want to buy an LCD, but you really want to see how a Gamecube / PS2 / Xbox look like plugged in to one. If they don't want to go through the hassle of hooking up a console to the LCD, make sure you let them know how serious about the purchase you are, and always ask for their business card / employee number (so they know the commision will definitely come their way.)

Check it out for a few mins, then tell them you need to shop around a bit more and think about it.
Next time I bring my LCD home from the office I will plug my kid's Gamecube into it and see how it looks.
Dexter...