The reviews are abysmal for the most part, but some people here liked 6. I personally never finished it - I played through Leon's campaign and most of Chris'. General consensus is that Leon has the best campaign in the game, and if you don't care for it then you're probably not going to like the rest of the game since it doesn't really get better.
I didn't care for what I played, and I'll never go back and play it. If you want a better RE game, try RE Mercenaries. It's on PC, and it's much better.