Brand-new arcade CRTs are razor sharp, and certainly do not accept an RF signal (I don't think they accept composite either). With time the electron beam starts to diverge, and things can get a little blurry or color-fringey.
What I've found—based on limited experience with a "modern" arcade cabinet (Fix-it Felix Jr., a tie-in promotion to the 2012 film Wreck-it Ralph)—is that if you have an LCD or OLED that can do true enough blacks, the effect is very similar to having a brand spanking new CRT, even in arcade applications.
But that goes only for raster games. Nothing we currently have can replace the razor-sharp, completely unaliased lines of an original Asteroids and its vector display.
> if you have an LCD or OLED that can do true enough blacks, the effect is very similar to having a brand spanking new CRT, even in arcade applications.
CRTs are inherently less blurry when your eyes follow moving objects on screen, which they do all the time ("smooth pursuit"). The reason is that LCDs and OLED displays show each frame for the entire frame time (like 1/60th of a second) during which your eyes, and the corresponding tracked object, move. This creates a blur. E.g. if an object moves on the screen 10 pixels horizontally per frame, on an LCD/OLED you would then see 10 pixels of horizontal blur. This doesn't happen on CRTs because they flash each frame only for an extremely short period of time and are relatively dark otherwise. At 60 Hz, they don't show the frame for 1/60th of a second, but about 1/1000th or something like that. This time is so short that during it, even fast moving objects and the eyes that track them hardly move at all, which results in basically zero blur. See https://testufo.com/ to see the blur. On a CRT, with matched FPS and Hz, the test would appear completely sharp.
It is true that LCDs and OLED screens are much brighter (especially LCD) and that OLED has better black levels, but CRT screens have much better motion clarity.