I think it's maybe more often used in a derogatory way down south, up here it very much depends on your emphasis. As the comedian Kevin Bridges once noted, it is also used in a classic Scottish threat: "I'll kick your cunt in" which, though it might surprise you, is very much unisex