The answer will depend on the plane, but in my experience you normally will see sea level climb performance up through around 10k ft, and then it starts to taper off. With a naturally aspirated engine you will notice climb tapering off pretty much immediately.
The specifics will vary dependent on aircraft as some engines will hold power to a higher altitude than others. Also some propellers are better designs and will therefore maintain pretty close to similar efficiency up higher.
My opinion is that turbochargers are not worth the extra cost, weight, maintenance, etc. unless you are operating out of the rockies, and even then you can question how beneficial they truly are. The exception is in cases where you have turbocharged engines and the turbos provide you with more horsepower, which the aircraft needs - like with virtually every cabin class aircraft.
A fun tool to play with is the Borg Warner Matchbot:
https://www.borgwarner.com/matchbot/
All aircraft turbochargers are way older than anything that Borg Warner makes today. However it will show you some of the changes in just how hot intake air can get as you get up in altitude, and the resultant changes in horsepower. I've often wondered what sort of performance improvements we'd see with a proper modern turbocharger. On my bus just going from a 2000 model year turbo (which is realistically probably early 90s tech) to a modern turbo (released in the early 2010s) yielded a noticeable reduction in intake temps and better performance/lower EGTs. I'm sure aircraft would benefit similarly, as the turbo tech is from the 60s.