I have a 13" sony trinitron PVM monitor and a 27" sony trinitron flat screen crt. They both look excellent.
The early 2000s Sony CRTs are perfect because they have componant, s vid, composite and rf so you can hook up anything to it and it'll look great and still use a light gun.
I also recommend the PVM monitors, they look fantastic and are perfect for shmups.