I don't think Buffy ended horribly at all. It was a satisfying ending for me, at least, and that last season had some really great episodes in it. I feel like it successfully bounced back from the dark season 6 that most people hated and got back to the series mission statements from the beginning.