This term is to be used when you're mad, but "fuck" just won't cut it. It can also be used when you just feel frustrated about your own actions.
"SPUNKFUCKSHITPISS.. I can't believe I crashed my car... "
"Why did I do that in front of everyone.. Spunkfuckshitpiss "