Wife and I just bought a used 325CiC, a 2001 model. We got lucky because it only has 22k on the clock and is equipped with both the sport package and the premium package. She wanted a manual and we got lucky there too.
Very nice car. No issues yet but we've put less than 1k miles on it. My sole complaint - and I think that's even a strong word to use, is that the gearing is such that the engine is spinning over 3 grand at 70 MPH. I'd be happier with a longer legged 5th gear. The upside of the gearing is that the car is still reasonably responsive to the throttle in 5th at highway speeds. The engine is so smooth that it doesn't really bother me. The car is by no means "fast" but it's certainly quick enough and perfect for her. I can't comment on it's character change with an automatic but it's reasonable to assume that it would feel slightly less responsive.
I don't know if the 330's are geared differently but I suspect they are since the larger engine makes more torque. I do know gas milage between the two is very close. I'd guess the automatic is probably happier behind the larger engine.
Good luck, Dan