I've always thought a crowd that is really "into" the game is a great thing. It adds to the experience and can help get a team pumped up to perform. As long as it's positive toward your own team and not negative and derogatory toward the opposition, crowd noise is a great addition to a match.
A REALLY great crowd is one that can appreciate an exceptional play, no matter which team it comes from.
