That’s an interesting question. For me, if a game has too many major problems, it’s simply not good. That said, I think you can enjoy a lackluster game if you’re playing it with people you love.
That game for me is Sea of Thieves. I’d rate it 5 or maybe 6 out of 10 yet I’ve played it for ~500 hours because it’s a vehicle to spend time with my best friend who lives 1,000 miles away.