I prefer the freeform tabletop games, myself. Normal D&D feels more like a wargame than a roleplaying game.
If the DM rolls dies for any other reason than A) any possibility being an interesting one to take the game in, or B) the nice sound the dice make, then it's likely not a game I'll be that interested in. Shaggy dog stories should never, ever happen in roleplaying games, barring sadistic DMs.
All the best DMs are sadists, though. I know when I was running games, I would sometimes roll dice for no reason other than to make my players worry. The thief would start checking for traps on everything, the cleric would confirm that I know they had their usual healing spells prepared, the fighter, well, the fighter wouldn't care, there's a reason why you play fighters after all.
My real regret is no one wanted to run games but me, so I never really got to play my dwarven monk, Fisto'fury Hammersmith. I was gonna prestige class to drunken master. It would have been even better than the founder of my Hammersmith clan, Axeblade Hammersmith, who managed to triple nat 20 with the dagger I grabbed from my captor, killing him outright. Until they kept playing when my buddy and I went on a cigarette break and came back to being informed that the idiots woke a dragon up and got the party eaten. Last time I played with them.