So many of these arguments go back to what used to be the best, and for sure there was once a time when having to get an auto to satisfy one's wife was a real sacrifice. However, the auto boxes of today barely resemble those old, power sucking, three speed slush boxes. Many drivers of modern Porsches and Ferraris can only achieve 400m times using the auto and launch control, because the system is so much much better and faster than they are at changing gears for instance.
It has been shown time after time that modern 4wd autos are superior to manual in most circumstances, the glaring exception being a lack of engine braking which has been addressed by the fitment of descent control to many models these days.
As for what you like, that is different from what is best. There are plenty of folks who still love the old MG B. In a large, powerful modern vehicle I choose the auto option every time. If I was buying an STI Impreza, then I'd go for a stick, because I agree that is the fun option.