'Cancel' - Best or worst use of UXD?

Classic use of canceling an action.

"Are you use you want to cancel this action? Click 'OK' to cancel the current action or 'Cancel' to continue."

To some, this is considered one of the best examples of user experience design. To others, it's amongst the worst.

Thoughts?

keyboard shortcuts: previous shot next shot L or F like Z toggle zoom