A minced oath, an expression of dismay, disgust, anger, surprise etc.
Used like "what the hell" to add emphasis.
Said in excitement, shock, awe, dismay, or supplication.