Depends on the 330i in question...
Tough one - 330i's should be more reliable on account of being less raped in general. And in my opinion, it's the best-sounding of all the non-M 6-cylinder motors. And being an iron-block, makes for a great candidate for future forced induction conversions. Also, it's got traction control, a better air-conditioning system, and a more comfortable suspension.
As a daily, the 330i auto is actually a fantastically driveable car - as much as I intensely dislike automatic cars in principle, I've driven an Individual 330i AT and came away very impressed...
Standard E46 3-series interior is a bit uninspired though - the seats very flat and unsupportive, and I personally dislike the leather texture and the way it wears.. An Individual or Sports pack model would take care of that though.
BUT, if you're a hooligan at heart, find a very clean low mileage model 4-door M3 (easier said than done, I know), and you can afford to keep aside a R20k buffer or so for in case something goes wrong, it throws everything I've just said out the window. Grin and bear the compromises - stuff a comfortable ride, traction control and a more modern look - the E36 M3 is fantastic - a must-own at least once in your life.
Edited to add: Based on you saying you find the 328i taxing to drive and only use it on weekends, I'd say 330i for you.