I've always been one to mostly laugh at glitches in games, going all the way back to the Atari 2600 in the early '80s. Oblivion is no exception. If I see a dead bandit standing straight up in the air (rather than lying on the ground) I usually get a little creeped out, but then I'll start laughing. I don't expect perfection in videogames 100% of the time.
The only glitch that killed my game for me was (like I said) the Animation Bomb. It rendered two of my games unplayable. I lived with this, started a new game in both cases, and since this glitch only showed up after massive hours of game play (about 360 hours each time) I got over it. I'd like to see such a glitch NOT show up in Skyrim, but if it does (especially after 360+ hours) I can live with it.