Another E90 330i 6MT owner here. Definitely go manual. It's way more engaging to drive. I live in fairly traffic prone area (granted I don't really deal with it very often), but I still love it. I have never enjoyed just getting in my car and driving as much as I do with this car!
Also, I have driven automatic all my life up until this point.