Supercharged here.
The front of the car is a little bit heavier but that's only something you're going to notice the first day or so. The car still feels incredibly agile and I have since forgotten how it 'used to feel' (it was a year ago since I made the switch).
Power wise, it makes a huge difference!
Before, I could floor it.... have fun and still be fine in terms of speed. (~100km/h?)
Now, if you floor it... you need to lift off the gas after a few seconds because you're going too fast! (~150km/h... and climbing quickly)
I personally think it's a lot more fun
Real life situation:
Stock:
Imagine merging onto the highway. Right now, you're on the on-ramp in 3rd gear... redline it and dump it into 4th as you enter the highway. You'll be going around 120km/h or so.
Supercharged:
I take the same on-ramp in 3rd but by the time I'm on the highway I can easily be doing 160km/h... and on my way to 200km/h. (Which I don't do because it's dangerous.)
This should give you an idea of the different driving experience with forced induction vs stock.
Last, but certainly not least, it's nice to know that you can now match luxury cars on the road. You see an Audi a4? You see a Mercedes C300? You see a BMW 323i?
You know you can hold your own ground.