Most of the time, I prefer careful pulls. Yes, it can sometimes get boring, but if I'm in an at-level group, not too boring. The only time I've really been bored has been while playing with a friend of mine who is significantly higher in level. We did Ragefire Chasm, when it was green and grey for ME, and I must say, that was the most boring experience I've ever had in World of Warcraft. Ugh.
Tonight, we did Razorfen Kraul. At 35, I was still higher than I should have been, but the majority of quests were yellow for me. And he's about 9 levels above me, so he was way overpowered for it. Still, there were just the two of us. We got to a particular area (not sure exactly which one), and for some reason, he just goes running around in it. He told me he hadn't meant to aggro everything in the room, but he did.
Well, I can tell you that even though I said "Oh shoot" (or something similar) about a million times, ran out of mana at least twice (despite his shaman mana stream totem and my numerous mana potions), got stunned and silenced... I still had a wonderful time when we actually made it, both in one piece. It was great!
So, making the most of a single mistake -- great. But I think I'd have been unhappy and frustrated if that's the way the whole dungeon had gone. Everyone makes mistakes once in awhile, and that is when things get exciting. But I don't think I'd want to do a lot of dungeons with people who deliberately pulled too much to handle, unless, as lsfreak said, it's a group of friends goofing off and you know you're all crazy. If you're there to do some quests or for some particular purpose other than just going crazy, it seems disrespectful, prideful, or stubborn for someone to deliberately continue to pull more than the group can handle. Surviving despite that is fun, but let's not make it a habit.
One last thought: DPS is the most common class, but just because it's common doesn't mean it's easy. If someone hasn't really had much experience, I don't think it's fair to apply my comments about "deliberately" pulling more than the group can handle to them. In fact, I'd say it's probably harder to learn to DPS well in a group than heal or (possibly) tank, if only because it seems like there's nothing to learn. You just target the guy and do damage, right? Just like soloing, right? Whereas the healer and tank roles are much more well-defined as NOT what you do when soloing, so it's easier to remember we're not doing the same thing, and to find resources to help us do it better. I bet a lot of DPS users don't even realize that they're supposed to watch their threat and so on. Now, if they know it's their problem and they don't *try* to fix it, that's a problem. But if they're still learning their group role and just making mistakes? Not as irritating.
(Of course, this comes from someone who does not have a lot of experience in groups, so take that as you will).