TPP stealth is fine. FP is generally superior (as it is for many game genres), but games designed around the use of TPP can still be great.
Anyhow, Stealth gaming peaked with the very first set of 3D stealth games (Thief, Tenchu, MGS, Deus Ex, Syphon Filter, Hitman etc) and it's been mostly decline since then, with the occasional worthy game here and there. At least in regards to AAA games. There's been a few notable stealth indies.
In regards to AAA, stealth has devolved into awesome button takedowns, infinite see through walls batman vision and invisibility on demand. Usual crap that plagues most games these days like banal level design, objective markers, and a generally easy game experience overall. I don't think I've seen AAA game where getting spotted meant instant game over since the 90s. Now that created some real tense and immersive sneaking.
but I gotta say many games include stuff I'd love to see in a stealth game, but none of them have implemented it all at once.
Such as?