Much like the term fucked, this implies being screwed, in that shit is about to hit the fan for you. Motherfucked implies that the situation is far more grave.
"Oh man, Jimmy owes Johnny 400 bucks and isn't gonna pay it back"
"JIMMY IS MOTHERFUCKED"
Prices shown in USD.