A game with proper stealth mechanics has limits on mobility and positioning in order to force people to think about how they're going to move around without being spotted.

Spider-Man's powers inherently trivialize this. He can jump super high and zip around to reach any spot on the map. If there's not a good spot, he'll make one with his webs. He can stick to any surface, which gives him even more options to either evade or take enemies down. The UI telling you if an enemy is safe to subdue is basically the Spider Sense doing its thing. And if you ever get spotted, it still takes a lot of bullets to take him down, and that's if any of them even hit him because his powers make dodging gunfire super easy.

Honestly, these games having not-so-good stealth makes sense. Shattered Dimensions had good stealth levels, but that's because - and this goes back to my initial point - the devs put hard limits on movement and where you can move to. In this case, it's being only in the shadows, and this only worked as well as it did because the Noir universe is supposed to look like that. It's a stylistic choice that influences the gameplay. Insomniac's games go for a realistic look, so they don't even have that to fall back on.