Over the years the majority of my cars were manuals (11 manual, 3 auto). If I had a secondary fun car again, I wouldn’t hesitate to make it a manual. Like you ran into, my daily commute involves a lot of slow traffic, and I just lost my enthusiasm for rowing the first couple gears so much. Went Auto with my current avant (no choice for this model), and have been super happy with it. It’s just a conventional 6 speed auto, but the programming/gearing is great. Sport mode actually shifts it where you would have, and it does it’s own little throttle blips to soften the decel downshifts. For a 4,000 lb wagon, it’s way more fun than it should be (Eibachs, a hotchkis rear bar, and some Pilot Super Sports don’t hurt...

).
My job probably helps make it so I don’t miss having a 3rd pedal - I drive plenty of other people's manuals, so I don’t ever even get the itch to go back.
Reminds me of my Chevette (oh yeah!) I had when I was 16. It was an automatic (but RWD), so it was painfully slow. But, I figured out if you manually shifted into L when you went speeding into a corner, it’d lock the rear up briefly and let you hang the tail. God, the things we did before mechanical sympathy... I remember watching my rear seat passenger relocate from the back right seat to the back left during one of those maneuvers since he wasn’t belted in (which I had noticed) and he didn’t have any warning (which I didn’t give him)...