I have one and I LOVE IT. It has no trouble playing anything at its proper aspect ratio because a: it's from 2004 when most content was still 4:3 and 2: it's a top level $2500 TV from Sony, not some cut rate "size matters" piece of shit Vizeo. My newest TV is from about two years ago but nothing I've ever owned has forced things wide. I consider that a mark of a bad product but I don't review TVs for a living so I don't know what's normal. Regardless, the XBR960 is a miracle. One of the greatest CRTs ever.
However, I can't really recommend it for SD gaming. It's designed to play LDs and DVDs, you know, movies, and while games certainly don't look bad at all on the thing, it's not like what people think of when they thing "CRT". It is an HDTV in every way. All sorts of fancy signal processing that you can adjust but never turn off. Even an HDMI input. It scales everything to whatever its native res is...I can't remember, 720p I think. It does a flawless job of it but it becomes totally smooth and sure as shit has no visable scanlines at all. I do play games on it all the time but my PVM crushes it in what we consider a good picture for gaming. Let's say B- with the qualification that there is a lot of variation in taste in this department. PS3 and up look amazing. Blurays are holyf*ckamazing.
For your LD collection, absolutely, for PCE...only if you already have it for your LD collection.
Also, it weighs 250 lbs, doesn't have good handles, and nobody I've found will even attempt to repair or calibrate one, largely due to it being a house call situation. For the hardcore CRT enthusiast these concepts are thrilling but it is extremely impractical. I'm almost (almost) glad LCD exploded in popularity like it did because TVs really couldn't get much heavier than this and not damage some homes.