Youre going to get 2 opinions on this:
1) No way, N+1. you can't live without a rowdy Enduro-bro trail slayer, a razor-sharp XC weapon, a 4 pound aero road bike, a choose-your-own-adventure awesome (TM) CX bike, ...etc. More is better.
2) All you need is a steel, rigid bike that you ride everywhere. It's what we did in the 70s, 80s and 90s. Now get off my lawn.
Personally, I don't think you're crazy at all.
I ride a steel hardtail (Vassago Verhauen) with a 120mm fork and a dropper. I also ride 100% singlespeed, but that's irrelevant, I could add a 1x drivetrain with 10 minutes of wrenching. I know I'm an idiot limiting myself to one gear.
My only complaint with my bike is that it has a 27.2 seat tube, so my droppers are limited to 100mm drop. Again, that's beside the point. A 31.6 tube wouldn't change the 'purpose', and I could only actually fit 125-130mm of drop, so...
To address your point-
My hardtail does everything I *need* it to.
To me, It's all day comfortable. I've done epic 50+ mile, 6-7 hour rides on it. I could take it bikepacking tomorrow if I wanted and would be happy with it.
I have commuted on it, but the lack of fun was due solely to it being SS, and trail-geared, not the frame.
I've ridden double black-diamond Sedona trails on it and while probably not most peoples cup of tea, I had a blast. I'd happily take it to Moab, knowing that I won't be setting in Strava KOMs on Cpt Ahab, but that's not important to me.
I've hit waist-high drops to flat on it and it handled it fine. Drops aren't off the menu in any way.
I'm not limited to buffed, rock-free trails. Those are very uncommon here in AZ. Of course my ride would be smoother with FS, but I ride plenty of heavy chunk without complaint.
I rather enjoy the feeling of being 'connected' to the trail, I recently borrowed a Rip9, and TBH, I didn't really like it, despite really wanting to. I also rode a friend's Fuel EX, and between those two realized I just don't feel the need to have rear suspension.
I also don't miss maintaining suspension pivots and servicing/tuning rear shocks.
Ultimately you have to decide what you need your bike to do- if DH KOMs and GoPro 'Shreddits' are a priority, then a hardtail might not be the right bike. (although, YouTube search "Hardtail Party", it might change your mind),
I personally believe most riders are way overbiked. I don't judge- bikes are toys. Play with the toys you want, I don't care. I'm just saying very few locations need a 140mm slacked out EWS trail slayer for general riding.