I had one pillar puzzle where i just couldn't figure out the solution...in the end i just tried them all (4 pillars, 3 sides each) until i got it...i had a lot of poisened arrows stuck in me...
Yeah, I don't see the point of most of the traps they have in both Oblivion and Skyrim. The poison darts don't do anything other than make my guy scream and turn the screen green. The flying mammoth tusk traps usually mis my head, and if they do connect barely do any damage. The bear traps don't do anything other than stop my character for a few seconds, they don't even alert the guards when I set them off. I hope traps are implemented a lot better in the next TES game.
I did find a puzzle that took me a little bit to figure out. There were 4 pillars, and the picture of the correct animal was above each. However, turning one pillar would turn the other ones, so you had to turn them in a specific order. I wish they had more variety with these crypt puzzles. I want Indiana Jones style traps, with some actual danger involved....