Basically, this phrase is the same thing as "motherfucker", but I invented it. I basically use this phrase when I'm pissed off. Either that or "God fuck!" So, yes. Use wisely, kids.
"Mother of fuck! I can't get a mother of fucking "A" on my test!"
*Literal example* "Mother of fuck! Why can't I make any {basketball} shots?!"
An expression used to vent frustration/pain/almost any other feeling expressed by the word fuck, typically as an alternative to mother fucker with the added emphasis of the mother being unholy (except for it is a mother of fuck, and not a fucker of mothers).
Unholy mother of fuck! What is that?!
*stubs toes on coffee table*
UNHOLY MOTHER OF FUCK! FUCKING COFFEE TABLES!
While our lifespan is the number of years we will live, our healthspan is the number of healthy years we will have and our sexspan is is the number of years we will continue to be healthy enough to continue having an active sex life.
A lighthearted reaction upon receiving disappointing news of some sort. Usually something that isn't a particularly a big deal, esp. when it primarily affects someone else - sort of a mild schadenfreude. Sometimes doubled or tripled, and possibly said in a sing-songy voice for added comedic effect to imitate a muted trumpet, which is how the meme originated.
You didn't get any napkins with your takeout pork fried rice? Womp womp.
A phenomenon in film/television series, most notably streaming series, where the main premise is drawn out to such a point that it takes an entire season or more to get the parts of the series the audience is actually interested in seeing.
For example, if a series is titled "Surf Dracula," a majority of viewers would tune in expecting to see Dracula surfing by the first or second episode. However, the entire first season would instead be tedious padding and backstory before finally ending with Dracula surfing in the last five minutes of the season finale.
I watched "Smallville" on Netflix the other day. Dude, it was ten seasons of filler before he finally flew! Major Surf Dracula Syndrome!