Used like "what the hell" to add emphasis.
A minced oath, an expression of dismay, disgust, anger, surprise etc.
An expression of amazement: holy cow, holy shit.