A minced oath, an expression of dismay, disgust, anger, surprise etc.
Used like "what the hell" to add emphasis.
A riposte to someone who has just said something obvious