This is a simple question that is nowhere near as simply answered. I'll ignore my favourite soapbox, which is high performance diesels, but will cover that topic quickly;
I have yet to drive a NASP diesel with anything other than leisurely performance. If you have any ideas about useable performance then forget NASP diesels. You can also discount anything without electronic high pressure injection - even if it is turbocharged.
Petrol cars are a different matter. We'll discuss factory tune for now.
VW/Audi is an interesting research point. VAG's 1.8 litre 4 cylinder, 20 valve unit is available in so many flavours. The NASP engine delivers 125bhp and drives very nicely indeed. Yes, it's ploddy, but quiet and comfortable; in fairness, it gets on with the job in a pleasant kind fo way. It's also available in several other levels of turbocharged tune. 150bhp is the very modest one. In the Audi TT this can be had with a 250bhp spec. Yep, it goes.
Ignoring diesels (as the differences between NASPs and turbos is too wide to consider) in general you can expect, for example, a turbocharged 2.0 litre four cyl petrol to offer similar power and torque to a three litre V6 petrol. The turbocharged motor will probably be more economical in fuel terms than the 3.0 V6. The V6 will probably sound nicer, and will probably last longer, although lots of manufacturers are now designing engines with a view to offering them in turbo form only so cooling issues should never be a problem.
I depends really on how you like to drive - turbochargers can be exciting and offer some silly gains in performance on paper.
Personally, I still like the idea of a quad cam large capacity V8 with everything done in a nat asp kind of a way. With an auto box.
Yet, I drive a manual 2.2 litre diesel. And it's nowhere near as bad as you'd think.