I used to drive a manual. Lived a lot more rural at the time, and it could be enjoyable. Now I live in a city (DC) and fuck that noise.
That being, said there's no 3rd option, EV, which are a single gear and have no transmission. A great feeling when you can just floor it and not have to be slowed down by gear changes. No stupid bubububu noises, no buzzing engine, just pure quick, quiet, and smooth acceleration.