I don't think most players want to fuck Sharon over per se, I like Sharon a lot myself the problem being that at this point in the story Sharon needs to realize that MC is the true power in scottstown and not her. He's at that point where he no longer needs to obey Sharon with regards to big decisions.
I generally like Sharon a lot.
Even though both her and Andrew were acting like idiots during Callisto's visit, which I wasn't too keen on seeing.
I think with Sharon, her biggest issue is her pride & ego.
Pride & ego was what made her take the not so smart decision of challenging Callisto (despite her being one of the elder), which MC has been warning her time and time again.
And I'd assume also pride is part of the reason why she gets upset and even resentful towards MC (if player chooses to hand Astrid over to Callisto), although a huge part of it's to do with MC basically going behind her back breaking her her trust also.
Unless she deals with her pride and ego, I don't think she'll accept that MC is the true power, and she just got the Archon seat thanks to Callisto pulling some strings for her favored "lamb" (i.e. MC), despite being told that it's not due to her own merit that she got the Archon seat.
Also, while I think one part of the issue is Sharon's pride and ego getting in the way of accepting MC as the true power of Scottstown, the other part of it likely has to do with MC's personality.
From what we've seen of MC sofar, he's more of a type to delegate a lot of Archon matters to Sharon rather than take charge of matters himself, so I don't know how that will all play into as a factor.