This is an ongoing struggle for me. I grew up with cars and, like many here, they provided access to opportunities and communities that helped to shape my identity. Being an enthusiast in many of the ways I used to find exhilarating as a youth (more power, smokey burnouts, etc.) is now at odds with the values I hold, especially after finding this board several years ago. However, my industry requires lots of time on the road, so it's hard to detach from car ownership altogether, even if I were to rearrange my life in ways frequently suggested by MMM.
For me, the answer has been a Fiat 500 Abarth. It's no bigger than I need, has very cheap consumables, and is an absolute riot to drive at all speeds. While I accept a higher level of maintenance for an enthusiast car, the Fiat has been surprisingly reliable with no major unscheduled maintenance up to 90k miles. Alternatively, I would suggest a Miata or other affordable roadster, but I often haul kids around and need the back seat. Many fun four-cylinder options can be had reliably for no more than four figures.
If and when I hit full FI, I may go back and examine other options with V8s, but I suspect the desire may not be there.
Good luck as you find what works for you.