I have a 6 speed manual, a 5 speed manual, a DCT and one with an auto. I even have a manual transmission on my office desk.
It’s an easy one for me. Analogue cars suit manual. There’s not much to compare to the experience of a naturally aspirated high revving V8 attached to a manual gearbox. It’s just driving therapy on the right road. Not much fun in traffic though.
Also older cars must be manual, mainly as auto boxes were absolutely horrendous back then and really affected car control.
Newer ones suit DCT or auto. Just sort of goes better with the experience and even good autos lock the box, keep your chosen gear and give you great control with the paddles.