Wisdom teeth removal is a very harsh procedure. You also don't want to be awake during hip or knee replacement where they use power tools and a lot of force.

But for other procedures I think being awake seems an interesting thing.