I actually really like a lot of the ideas and themes introduced in season six, but I would have hated to see it as a finale. It's a good idea for a season but then was filled with horrible writing decisions made at the last minute, and the "twist" ending where Spike gets a soul is especially horrifically executed and needs nearly an entire season of follow-up to even get a point where it's not insanely annoying to think about. In order for season six to have been a good ending, a Spuffy-centric arc would need to take up a lot less time so Buffy can actually be a more central part of the arc around Willow, the actual Big Bad of the season. Anything related to Spuffy stops feeling like any thought was put into it at all about halfway through the season and then just lingers with cheap shock value until the finale, and ending the actual "relationship" phase a lot sooner would possibly provide a way for there to be some kind of "escalation" that triggers Spike to get a soul without that moment having to be SR, I think.
I do think season three would have made a really strong ending. Probably I would have said that would be where the show should end, if I had seen that season before anything after had aired. But I do kind of have a soft spot for Spike as the comedic relief in season 4/early season 5, and I really love Dawn, so I'm glad the show continued. Season 5 has such a perfect ending that I do sometimes wish the show ended there, even as a fan of season 6. The finale we got is just not nearly as fulfilling, and season 7 becomes the "let's all feel sad for Spike, who is wallowing in misery" season, which is so incredibly annoying as someone who actually likes Spike and was interested in seeing the consequences of what happened in season 6.
Season 3 would definitely have made a good endpoint, but we'd have been denied many wonderful post-high school episodes and I'm personally glad that they let the show and characters evolve beyond the teen years. Season 4 in particular is one I have always had a soft spot for and it makes me nostalgic for my own college years (though there were fewer vampires on the campus I attended). It works well as a soft reboot of the show and I'm grateful it was made. Season 5 generates a mixed response from me. I like that it's not afraid to take risks and the ending is superb (and would have made for a shocking and yet exemplary conclusion to the series), but it's heavy in a way Season 4 isn't and I never came to love Dawn. She simply irritated me throughout Seasons 5 and 6.
Like you, Season 6 has elements I love and elements I hate contained within. The Trio can get lost as far as I'm concerned. They'd have been fine as minor villains in two or three episodes, but that's about as much as I can tolerate from them. And the abusive sexual relationship between Buffy and Spike is something I have mixed feelings about as well. I do like the darkness, Buffy's struggle with depression, individual episodes such as Tabula Rasa and Once More, With Feeling and the whole Dark Willow concept. But it would not have served as good conclusion to the series in its existing form.
I've been working on my own reimagining of Season 6 and the Dark Willow arc for fun.
I would completely alter the motivation for Willow's embrace of dark magic. I'd have had Willow expressly utilise black magic to resurrect Buffy at the start of S6, inadvertently causing a zombie outbreak in the process. In this, she acts completely alone, with the Scoobies unaware of what she is up to.
After successfully reviving Buffy, Willow is elated and her self-confidence in her own abilities grows exponentially. She resents the fact that the others harshly criticize her recklessness and Buffy's ingratitude (due to being depressed).
Willow's increased confidence and resentment at not being properly appreciated lead her to further embrace dark magic, convinced that she can outdo even the Slayer and using her magical powers to control evil. Eventually, she comes to the realization that all supernatural entities can be controlled, but it requires an immense amount of magical power. And human souls. So she starts stealing people's souls, effectively killing them in the process. She starts with prisoners and evil-doers, but it isn't enough. Over time, her actions, done in the belief that what she does is for the greater good and fuelled by ever greater exposure to dark magic, result in her complete corruption, which is so all-consuming that it has led to changes in her complexion, her skin now taking on a sickly shade of green. Local demons who spread rumours about her call her the Emerald Witch as a result.
The Scoobies search for this soul-stealing demon, unaware at first that Willow is the perpetrator. In the end, she concludes that her plan will require access to the energies contained within the Key (Dawn). Tara tries to stop her, but is unsuccessful and injured in the process. Willow's obsession with the success of her plan and her hubris override even her concern for Tara.
Ultimately, Willow abducts Dawn with the aim of converting her into pure energy. Buffy tracks her to her hideout - a cabin in the woods - and manages to stop her in the end, but not without both suffering serious injuries (in one very dark draft I have Buffy actually having to stake Willow in order to stop her from completing her spell).
Meanwhile, Spike and Buffy cultivate a quasi-romantic relationship. He wants her, but she never gives in to his sexual advances. Though she does become co-dependant on him in other ways. Her frequent sexual rejections cause him to abandon her late in the season, meaning that he's not there to help her rescue Dawn and stop Willow. He finally does track her down with the rest of the Scoobies after having a change of heart. Devastated to see that his abandonment led to her serious injury, he is consumed by guilt. This guilt motivates him to seek to become the man Buffy wants - that is, to seek out a soul as in the canonical series. No sexual assault, no sordid sexual relationship necessary.
In my version, this Dark Willow is the season's Big Bad. There is no Trio. Or if there is, they play only a minor role.
Oh, and Xander should have married Anya.