Yeah, size and weight aside I feel like the CRTs I've used in the past weren't close to the quality of the ones people show on 'CRTs are amazing' videos.
I have no idea if it actually works for pixel effects, but the only CRT filter I like is triangular filter (offset rows gives honeycomb-ish pattern rather than lines/screen-door effect). Which would likely also make finding a CRT I actually like harder too.
EDIT: And I could take-or-leave the filter still (except for when it clashes with CRT effects in games), though I do like what it does for 2D (UI elements and pre-rendered stuff) plus toning down the brightness on full-white screens (like intros/logos especially).