I drove nothing but manuals for the first 15 years after getting my license, 4 cylinder and 8 cylinder. As the family came along I moved to an auto as the wife was not fond of manuals, so been driving autos for a few decades now, every now and then I drive a manual, my daughter has a manual Subaru, bit like riding a bike, I drive it every now and then, she leaves it at my house when on holidays, she is overseas with work at present for 12 months so I have been using it fairly often, I enjoy driving the manual, but if I was to buy a new car I think I would probably buy an auto.
Quite a few different autos on the market, not keen on these CVT autos, my son had a VW Golf with the DSG auto box that was a bit of an odd thing at times, if I bought an auto again I would prefer a traditional torque convertor auto. If the wife stopped driving before me I might consider a manual again, depends on the car I was considering and what type of auto it had.
Many years ago I worked as a driving instructor, taught lots of people to drive manuals, could tell you lots of funny stories of the people I taught.
Never got involved in motor sport, but definitely would go the manual in that case, almost had a go at motor sport, I built a very potent
Morris Cooper S back in 1968 for hill climbs but due to family issues never went ahead and actually competed, used it as a road car for a few years then sold the car to a friend who used the engine in a newly developed motor sport called Rally Cross which they ran at Calder Park.