Escorts asside, I think Star Wars Republic Commando is the example of NPC support done right.
You don't have to worry about them dying, but they aren't invulnerable. You don't have to worry about their ammo, but they'll only use their best weapons in specially designated positions. And best of all you can actually rely on them.
You don't have to worry about them dying, but they aren't invulnerable. You don't have to worry about their ammo, but they'll only use their best weapons in specially designated positions. And best of all you can actually rely on them.