I grew up with CRTs and bought one at a retro game conference to put on my desk for some gaming. I had all but forgotten the deafening noise they make. The sound is hard to describe if you have not heard it. The sound hits different than an arcade with a bunch of noises and music and everything going on, but in my generally quiet office you can hear it from 2 rooms away when it is on. I tend to prefer how the SNES looks on the CRT compared to any modern screen with super sharp pixels, but that is easily (expensively?) fixed with a RetroTINK 4K to get the CRT style filters. The noise is just something to consider I don't see discussed often. My cats had never heard that noise and it freaked them out the first time they heard it.
https://www.retrotink.com/shop/retrotink-4k