I have a few old radios.
If you want a tube radio I suggest a Drake TR4, yes the PS may need recaps. I sold my tube Collins set because I thought the TR4 sounded better. (can't keep everything)
The 940 has a bunch of problems but it is so popular that people fix it all the time, lots of resources, I prefer the 930, I think there are fewer problems.
These are both really great sounding radios.
The Kenwood 520, 530, 820, 830 series are good also. I have repaired a few.The receivers are pretty good, no AM. The 830 is the best one.
The Yaesu 101 series is popular still. Many have been used on CB bands and have "mods" and have been beat up. The 101 ZD is a different radio and is more difficult to get on CB bands, it is a good radio.
The Kenwood and Yaesu I mentioned only use tubes in the Transmit section.
Icoms are good also.
I'll hold my comments on Heathkit and Hallicrafters for now, other than they are easy to maintain.
Most old tube radios will require PS cap upgrades soon if not immediately. Not hard, just takes time and is a bit expensive only if someone else does it.
You wish to get exotic??
I use a Military GRC 106 and a Sunair military type radio. The GRC is good and can be repaired, The Sunair is a mystery to work on.
There are groups on Groips.io for each of these radios.
Wally KC9INK