^ pet hate in bad interface design, so NO!
For sure !!!
The software product that I develop does have ... "Are you sure ?" in "destructive" areas.
I had a customer ask me to put an "Are you sure ?" in a dialog that was just flat out silly to ask the question.
I asked ... "Why do you think it is needed there ?"
He said ... "Well, maybe that's not what he really wanted to do ... so I think it would be good to confirm it"
I said ... "OK ... so when he answers "Yes" to "Are your sure "? ... should I then pop it back up and ask ... "Are you REALLY sure ?" ... and if he answers "Yes" to that, should I then pop it back up and ask "Are you REALLY REALLY sure this time ?" ... and should we use this notion through out the product for consistency ?
He dropped the request.