Timing and location makes all the difference. I've had terrible experiences, and nice ones. The nice ones were like when I saw "The Martian" last year: we went when the movie had already been out a while (it was probably just about done with its run at that theater, not sure), and we went I believe on a weekday night, so there was almost no one at all in the whole place. I think there were two other patrons watching The Martian with us in that theater. When you can catch a movie like that, it's a pretty nice experience. Of course, if you have a nice giant-screen TV and your own home theater room, I'm not sure what the theater offers that beats this.
I've also gone to a few movies at a dinner theater in the city I used to live in, and that was pretty nice. No noisy teenagers or inappropriately young children in theaters like that (they serve alcohol, so they're probably not allowed in, plus it's not the environment they'd like).
But any rather recent movie, in a non-dinner theater, at a time when there's likely to be a lot of people (esp. young people), is probably going to be a miserable experience. It's really a lot easier to just avoid it altogether instead of trying to game the system to figure out when the optimum time to view the movie is.
Also, having trouble with uncivil patrons once a year is too much: I probably don't even watch 12 movies a year, so that's a high probability of a bad experience. And all it takes is one bad experience to make me think thrice about bothering with a theater. I had a bad experience back in 2007 watching JJ's "Star Trek" and my movie-viewing (in-theater) went way down after that.
But again, timing and location make all the difference, plus how recent the movie is. Some localities have very, very different patrons than other localities, the mix of people changes drastically depending on the time (matinee vs. evening, weekday vs. weekend), and the mix of people changes based on the movie itself and how old it is (e.g. first week of a Star Wars movie vs. 5th week of some chick flick or boring adult drama).
Finally, there's some things that are universal. For instance, everyone needs to use the restroom at some point, and movies never have intermissions (in American movies at least). So people who urinate a little more often are going to be unhappy no matter what with a theater, whereas watching at home doesn't come with this problem because of something called a "pause button".