It didn't mean the same as cunt in Scotland until very, very recently, and I reckon it is still used here with the same meaning as twit or eejit. It's dismissive but not in a disgusting way, just a scornful way.
However, words change all the time. Even the power of cunt will fade in time.
Not that it's a word I've ever felt the need to use. After all, how silly to call someone after a woman's pudenda and vagina. I suppose it's no worse than dick though, she says ponderingly.
It's the people using the word and showing their contempt for someone else who are the twats, not the people against whom it is used.
And, besides, as always, it depends on the context and the manner in which it's used. Fuck used among teenagers is no worse than saying Bother! most of the time, though they can and no doubt do use it more aggressively too.