Someone who you hate or can't stand to be around. The other meaning is someone you would like to shit on.
"Here comes the shitfuck Brad."