I will be sad to see the show end, but also I think it has run its course. The end of Buffy will also mean an end of an openly out gay character on TV (for those who don't know, I mean Willow).
As for who think the show was bad, you should rent the movie, now that is crap!
What I fear is that...