I have a 444HP 302 and a 305HP V6. I think it's a pretty good analogy.
The V8 has the rumble, ability to snap you back in your seat, and pulls forever.
The 6 is accelerates respectfully, is easy to whip around, and gets 30 MPG.
Sounds like the 2.3T will have about the same HP as the '11+ V6, better torque and better sound. It's probably not gonna snap you back in your seat, but will probably get you closer to the 50/50 weight distro, and let you skip every 4th fill up you'd have with the 5.0.
2012 Boss Yellow Blaze, Recaros/Torsen, Cover/Mats
2012 MCA PP Sterling/Lava