In British-English use it’s roughly equivalent to how an American might use “motherfucker”. Not least because if you try saying “motherfucker” in a British accent (any British accent, from West Country to the Hebrides) you sound completely ridiculous.