My last car was a 330i and I absolutely loved it. I've never been one to get all misty eyed over a vehicle, but the outstanding handling, fit and finish and generally thoughtful design of the 330 really won me over.
My only complaints, and they are minor, is the 330 could use a little bit more power (even with a standard transmission) and it is absolutely worthless off the pavement (I like to go camping now and then and the thing has like 3" of ground clearance). It's also nearly impossible to fit it with chains (though it does remarkably well in the snow without them). I think they've added a little bit of power since my 2001 model, so that issue may be taken care of.
Bottom line is you will not be disappointed if you get the 330. I enjoyed that car more each day I owned it and was very sorry to see it go.
Incidentally, I now own an Infiniti FX, which is basically the G35 chassis and powertrain with a different body, 4WD and gumball tires. I really like the FX - it has a little more power than the 330, handles really well for an SUVish type thing and does much better in the snow and off road, but it lacks some unquantifiable element of quality or craftsmanship or whatever that the BMW had.