I had a lot of thought into this topic and started writing (rambling) so here's a shortened version of it. Every car that I've driven extensively (dealership, friend's) or I've owned has a story to it. The enjoyment is more so in the reflection of memories or moments.
I often find myself struggling between making a practical and reasonable choice (read: boring - like an Ioniq Hybrid with 900km of range) or a "fun" choice like the Civic Type R. Like LP700 mentioned, if you daily drive the car it's no longer special to you. The Type R is too reliable. Too good. There's no visceral excitement like my previous vehicles.
I've come to (recently) realize that the "excitement" in my previous vehicles came from it being an absolute death trap (E36 M3) or mod creep (E46 330ci). I drove my friend's 964 C2 the other day. It was an absolutely terrifying experience. It's probably the most expensive car I've driven on the street, the steering is heavy as hell, the car rattles and feels like it'll send me off the road at any minute. It reminded me a lot of my E36 M3, so much so that I have confirmation that old cars are not for me. The Type R on the other hand, it handles everything with ease, and that's the beauty of it. I'm not constantly hyper aware of everything and I can just trust that the car will handle it. I don't even revmatch in the FK8 because auto revmatch is so good. And to be quite honest, revmatching in the FK8 isn't as satisfying as other German cars.
All my life, I've heard about how great these Hondas are. I'm blessed to have driven several AP1 S2000s, an ITR, FA5/CSX-S and to own my FK8, but I don't think the hype is warranted. [I have similar sentiments with my E46 M3. The engine sounded great but it didn't handle as lightly as my 330. Don't meet your heros]. Once you've done a perfect revmatch/heel toe in a German car, it feels so much more satisfying - the E90 M3, E46 M3, E36 M3, 964 C2 are examples I have driven and gotten it right off the bat.
In summary, I came to the conclusion that you just need to find the right car. For me, it's the Type R. It can be boring, but that's the beauty of something that can do everything. I just gotta get rid of the loud exhaust. All in all, I don't regret my car experiences - first track days, first RevScene meet, first auto-x, etc. I'm pretty blessed to have made friends over the internet on this forum, even after it's peak.
Notable mentions - daily drivers: