Hi there
On modern cars, even NA remaps make quite a nice change as the most noticeable changes come from more relaxed torque management.
All modern cars with drive by wire ECU's have torque management which can limit throttle opening when required, feels like TC kicking in or not getting full throttle sometimes. If you car has such symptoms than a remap can certainly help a lot to improve drive ability.
Then of course improvements of more power, torque, throttle sensitivity are all additional bonuses. Turbo cars tend to see even great gains due to being able to add a little extra boost.
On the whole on more modern cars it works well, on the older NA cars it is more hit and miss, my 911 the remap alone made little to no difference, yet on my even older M3 the remap added welcomed additional power in the 6000-8000rpm range.
Also on many cars now they put the same engine in several models, if you have the lesser model then the remap can literally upgrade you to the next model or two up in the range and unlock the potential disable at the factory on your model.
On the whole a remap can work well, but always, ALWAYS get it done by a company that has experience and a great reputation, don't try to do it yourself and don't take it to some guy down the road who reckons he knows what he is doing, because it is also just as easy to mess it up and kill the engine.