Auto transmission gear are the best but the drawbacks are more than the comfort such as maintenance is very high .but comfort comes with its own cost. You want to have real pleasure than go for manual gear. Modify it with some new pedals and gear boxes and of you go wroom. The real way to drive a car. All the cars with new have both automatic and manual variants. Nowadays we have a lot to choose from.
I have a honda city manual and my friend has a opel astra auto but you will always love to drive a manual than a auto
Its a experience you should have both manual and auto.
The best manual cars were manufactured in the past rather than todays or recent cars // to have a real experience buy a old car and make some adjustments and tunings which are very easy and can be done at any good garage .
Thank you.