Says a guy who's probably never owned one.
Every single antique car I've owned and enjoyed is a ragtop, from a '46 Series 62 to a S1 DHC to a R129. I owned one antique hardtop (a very rare '68 T1 Park Ward LWB car), sold it, because I wanted something else open-air. I do own an old truck; it's as much utility to bring home 2x4s, trees, and plywood as it is to tow said open-air cars.
When I'm out on a warm summer evening, top down, in a vintage Corvette with my wife, or with the roof pulled back on my '63 Impala, and my family with me... My daughter keeps asking if we can take the 2CV out, even when it's 40 degrees in early spring, because she wants to ride in a ragtop.
As an aging man (not *quite* old yet), if I'm out in one of my cars alone, I'm alright if you think I look stupid. You're the least of my worries. 🙂
You wanna collect fixed roof vehicles, great. I believe if you're going to own something impractical that rarely cool temps, let alone rain, snow, or the like... Go for it. Make it completely impractical.
An ex owned a '01 Cabrio. Other than typical VW electrical issues, and being incredibly underpowered, it was a fun little car. She loved it. Triple insulated roof worked fine in all weather. Rabbit Cabrios are similar. Great little vehicles. Try one, they're cheap enough...