At least in some CN, level one qi gathering, strong as ox, fast as horse and impervious to mortal weapons, can still be beaten and killed by mortals with batman-esque prep and magic apprentice can still die like easily once magic is dry.
I hate power scaling. Anything beyond city busting is just narratively unnecessary and intellectually bankrupt. You gain little, but you lose all sense of consistency in exchange.
Solo Leveling is an amazing Manhwa, the anime sucked. But the author was open about not being able to figure out a logical reason to not use guns in dungeons, though that answer exists.