To me, CRTs are all about the picture motion - it's just so much smoother compared to LCD.
Yes, modern LCDs with high refresh rates and "low lag" have come quite far.
But still, I find a 1024x768 moving image on a CRT to be equally or more sharp than a 1080p image on a gaming LCD. The problem with LCD is that the moment the image on the screen starts to move, pixels will blur. High refresh rates can only go so far. In the end, the pixels on an LCD screen are just "lazy" compared to CRT, and that's because each pixel is driven by individual small transistors in the LCD matrix that will always have some turn On and Off delays... which is why when LCDs advertise response rates, the manufacturer NEVER tells you that this response rate is from full On to full Off (e.g. full black to full white pixel.) If they had to do that, you'd see the response quickly go into the many 10's of ms.
Sorry, but LCD is just not as clear on a moving picture. With very high resolutions of course, some of that will get compensated for. But then that just requires an ever-increasing graphics power to do.
Other than that, though, LCDs are great. For daily office work, I'll take them any day over a CRT. CRTs are harder to see in well-lit rooms compared to LCD, always have non-perfect geometry (might be a bigger deal to those working with CAD software of some sort), and are very hard to calibrate to have neutral color temperature in their entire color range. LCDs are simply superior in those areas. The only thing CRTs are better at, color-wise, is that they don't have a pre-set number of gamma levels, unlike LCDs. "Infinite number of colors" are possible on a CRT, as some would say. This makes CRTs a little bit nicer/easier to adjust when you want true black levels (where the monitor looks like it's completely off when displaying black). I actually have a few CRTs calibrated this way, and they make for an amazing cinematic experience with some games - e.g. Half-Life 2, Nightmare House 2 (holy shit this game looks so much scarier on a CRT than on an LCD), and a few others. That said, I also have a few CRTs that were factory set to be a little brighter... namely a 19" Syncmaster 955DF. I use/d this one for some modern games up until a few years ago (Fortnite, CS:GO before CS2 came out, and etc.) Unfortunately, the PC I was playing these newer games on was not that good and could not provide a constant 60 FPS (or even that much.) So I couldn't get the best experience out of it. But I really want to experience Fornite one day with its fast building pace on a CRT set to 85 Hz and the game frame-limited to the same FPS. IMO, that would look much smoother than 240 Hz on an LCD, despite improvements in technology. No matter how much better LCD gets, it will still have limitations in that regard.
Anyways, as far as CRT monitors, I have kept all of mine that I've collected over the years, even after moving across the pond to EU. It was expensive to ship them... but it was either that or try to sell/give them away and know that I will never be able to have that collection again.
On that note, I do have the hyped-up GDM-FW900 and all I can say is... it's NOT anywhere near my favorite CRT monitor. It suffers from all of the issues that other "modern"/late Sony suffered from (over-brightness issue, anti-glare starting to flake off on one corner, poor colors and not terribly-vibrant picture, and bad solder joints.) All in all, I'm actually not that much of a fan of any of the late Sony CRTs. The Samsungs and LGs were simply better, picture-wise. Though one thing that's better for Sony than Samsung is that at least there are tutorials of how to calibrate Sony monitors with WinDAS. For Samsung, on the other hand, there just isn't that much info with regards to their "SoftJIG" software. And Samsung monitors tend to use less-than-great caps too (typically Korean brands like Samyoung and SamWha), so they will be due for a recap eventually, if not already. Sony at least used Japanese electrolytic caps, so except for the occasional failure on these (due to heat), they are a lot better built.
Oh, and I agree with the sentiment that you shouldn't just look for a particular CRT if shopping for one. Just get whatever is locally available, as suggested, and see where that takes you. FWIW, some of my favorite monitors are various Dell branded ones from the late 90's and early 2000's. Inside, they are made by different brands. For example, my '97 D1025HTX (17" CRT) is an earlier Trinitron build and doesn't have the abovementioned Sony issues. I also have a 19" Dell from 2000 or 2001 that I think is made by Philips. Picture-wise, this one is amazing and my most-favorite monitor. But build-wise, Philips had quite a few issues with flybacks on some of their CRTs. And while that's not a problem on mine (yet?), the plastic on the case has become extremely brittle - like a dry cracker - and I have cracks in the corners that keep getting bigger every year. It's only a matter of time before the tube falls off its mounts and breaks something and/or itself. I've seen that happen to a few CRTs (not my own, luckily... not yet, at least.) Another favorite Dell of mine is my M782 - a 17" from the early 2000's with a Samsung chassis and picture tube. The colors are top-notch and picture is nice and crisp. Nice bright tube too. It was a crazy random dumpster find that I carried home by hands for over a mile... but it was totally worth it.
Anyways, I never stopped using CRTs. They are just too good for certain things, like a moving picture. Of course, they are not for everyone. That they take a lot of space is the least of their problem. I think the biggest downer that people tend not to account for is that CRTs are not fit for use in a bright space/room. So if you like to game during the daytime or with lights on, you might get quite disappointed when you see how the picture looks on a CRT in a non-dark room. For starters, the glass absorbs any of the light in the room and reflects it back - even if the screen has good anti-glare coating. So blacks will never look that deep on a CRT if you aren't willing to play in the dark or very dimly lit room.
Also, I don't want to say that CRTs use too much energy, because compared to modern GPUs these days, they are almost like a fart in the wind. Nevertheless, if you've got one in a tiny or very small room and if it gets hot in that room during the summer, expect it to get even hotter with a CRT. In essence, they don't really use more than 70-90W during normal gaming use (rarely jump over 100W power consumption). But in a tiny room, you *will* noticed it compared to using a thin modern LED-backlit LCD that sips less than 1/5 of that power. Of course, if you're using your CRT on a setup with some power-hungry SLI pig-rig, then again, the CRT won't be the big stinker in terms of the heat production.
Oh, and one more benefit / cool factor of CRTs that I forgot to mention: the smell from their back when they get hot and the degaussing noise. I mean, that itself gives me an instant nostalgia trip. 🤣