Manual gearboxes are totally lost on me, always have been. I wont even have a manual rental car if i can avoid it.
I would genuinely rather drive a 3 speed 80s autobox of utter fail equipped car than a manual car.
I'd be inclined to agree with you for most of my normal everyday driving, I really love having an auto gear box. However the 5 speed box in my 330d is truly awful and I'd not want to step down any further. When I sell the 330d I will definitely get another auto or dual clutch gearbox.
However I prefer manual in sports cars. It has to be manual or dual clutch for me. If I was spending £20k+ again on another car it would have to come with a dual clutch box. The manual in my M3 is good, and my preferred gearbox for that car.