Nothing to be sad about... more horsepower more torque and better fuel economy.
You can't beat the natural smoothness of an inline six though. It's been BMW's defining motor for decades. Even if the new four cylinder is objectively better, it's still a bit disappointing to see such a fantastic powertrain get dropped. Much like when Jeep abandoned the venerable 4.0 when the 2007 Wrangler debuted.
I remember being awed by the smoothness of the N52 when I test drove it.
I am also a little sad that it's being retired.

It was also a very reliable motor, from what I understand.
I love the sound of the six but if I was buying a 28i it would be the n20... no question.
The n55 cars have a vacuum actuated valve in the exhaust that opens during WOT to provide that sweet exhaust tone (google golf tee mod). I don't know if the same valve is installed with the turbo engine.
Despite loving the smooth in-line 6's of BMW's past, the N52 unfortunately cannot compete market-wise anymore. The power (i.e. torque) and fuel economy trump the beautiful-sounding, silky-smooth, high-revving engines of BMW's (soon-to-be) past.
The engine on my M3 on order will also be outclassed (overall) by the new (likely) tri-turbo in-line 6 M3. Just like what happened with the old vs. new M5. The V10 of the old M5 will always retain certain attributes that the new M5's twin-turbo engine can't provide, but - overall - it's just wouldn't be competitive enough anymore in a new model.
If I had an N52 I loved, I wouldn't see the new engine (alone) as a reason to replace the car. It's still a terrific engine.
Interestingly, the fuel economy number of the N55 twin-turbo 6 is quite close to that of the N20 twin-turbo 4. Which would make me lean towards the N55 actually, at least on paper. I'd see with the test drive.

p.s. ZF's new 8-speed auto tranny also makes the new auto 3-series quiet fuel efficient. Check the differences with the manual versions:
2012 F30 328i 8-speed auto: 24 city / 36 highway.
2012 F30 335i 8-speed auto: 23 city /33 highway.
2012 F30 328i Manual: 23 city / 34 highway.
2012 F30 335i Manual: 20 city / 30 highway.Offical F30 USA MPG ratings from
www.fueleconomy.gov