Yeah, in fact I think that's a majority of those cases. Vocal minority of reactionaries and/or fans disappointed that their expectations weren't met despite the product on its own being good
Maybe not undeniable garbage, but I love Event Horizon and was shocked that people in general didn’t. But yes, I am fully aware that some moments in that movie is very much questionable.
This is one of my favorite movies. The first time i saw it, I was out camping with my friend's family and his dad decided that he wanted to see a movie, so we drove an hour into town. Friend's dad wanted to watch like Copland or something, and we asked if we could go watch Event Horizon instead. All of us thought it was just a sci-fi movie, so friend's dad bought us tickets. My friend was covering his eyes or plugging his ears for a lot of that movie, but that is when I realized I love Sam Neill movies. Back at camp was a little rough for both of us though. Neither of us slept much
Bram Stoker's Way of the Vampire is at --/11, and is absolute trash. It's also hilariously stupid and worth watching with people who enjoy making fun of movies.
spoiler
Van Helsing makes himself immortal, time passes, and he recruits a ragtag band of teens to fight vampires after he (ahem) teaches them kung fu. Big bad gives a rousing speech through Spirit of Halloween plastic fangs.
Let me just add that tomatoes aren't the only indicator of how much you're going to enjoy watching a film, resp. of how "good" or "bad" a film is. badmovies.org for example uses skulls and slime drops, and while the two websites may have very different rating criteria, both are legit and can be valuable sources of entertainment.
If you actually care what other people think only looking at Rotten Tomatoes is a mistake. I typically use Letterboxd with an extension that adds in many other sites