OP- you're not alone.
Still don't let it sour you on live music.
What I hope for is an "audience" not a "crowd", and a high Audience to Crowd Ratio (a:c). The more I like the artist, the lower ratio I'll put up with.
A "crowd" is there because they've heard of a band or have one friend who dragged them and/or his other buddies to a band they've never heard before. They may be there looking for a night out to drink and wind up at a concert when they really want to be at a bar. Perhaps they wants to sing along with the one or two popular songs they've heard (usually getting the lyrics wrong) forcing themselves into a particular scene they don't even really want to be part of themselves.
An "audience" actually wants to LISTEN to the music and ENJOY the show. Drinking/chatting/carousing may be part of the experience, but an audience is psyched that there are others at the show who have discovered the same band and the band is their primary reason for leaving the house that evening. They are excited and energetic, and as fans of the artist(s) themselves they want others to enjoy it as much as they do. An audience will enjoy have a few drinks as well, but keeps it to a healthy buzz that is usually good for the energy of the show.
The bigger the band, the larger the venue, the lower the A:C ratio gets. My limit is around 10:1. If 10% of the people are part of the "Crowd" that's enough to ruin a show for me. I also find mid-week shows are better than weekend shows for the ratio.
There are a FEW major bands I'd risk putting up with a low A:C ratio for. If the Police reunited again. Maybe Radiohead. I went to Nine Inch Nails (but from a buddy of mine's box seats which isolated us from the "crowd" and was great but kind of weird for a band like NIN, too). Willie Nelson (at Willie's concerts, the crowd can be as much part of the show as Willie is and I kind of make peace with that going in).
Otherwise, there's a sweet spot for high A:C ratios in bands that have a following and are maybe just getting traction, but aren't totally on the radar and play at venues smaller than House of Blues. In Orlando, we have a venue called the Plaza Live that gets some up and coming acts and is usually a good place to see a show. I've seen John Butler Trio and Citizen Cope there- both had a good a:c ratios of maybe 30:1. Wilco usually is up there around 20:1. I haven't been to their shows, but would imagine bands like Sylvan Esso, Courtney Barnett, Car Seat Headrest, St. Vincent (I have been to a St. Vincent show and she was great) might be examples of bands in this strata.
In conclusion... ummm jeez. Did I overthink that or what? I am really procrastinating at work today.