House sparrows (and purple finches) are actually being crowded out by the house finch across North America. The house finch competes aggressively for nesting sites. But it's a pretty little bird so I don't expect any anti-house finch sites to pop up.
I can't speak for anyone else but sparrows are far and away the most common bird I see.
I mean I'll grant that I like looking at blue jays despite them also being notoriously aggressive.