I am looking at buying a 330d Sport soon.

I idealy want a manual but i keep seeing the auto ones coming up for sale....

What are the pro's and cons of the auto/tiptronic box as i know what a manual is like

Many thanks