Probably a little off the mark here but honestly - TF2. The Spy class is essentially all about this - you're underpowered, playing against live humans and if your tactics aren't on point then you'll end up very dead. Very real need for real deception and stealth that I haven't seen in any game since.