Oblivion's stealth was pretty decent, and like everything else in the game, can be made better with mods. There's a particularly cool mod called "Thieves' arsenal" I think it was, that adds items from the Thief series. Gas arrows, climbable rope arrows, a blackjack, water arrows that can knock...