My $0.02? Realism can kiss off. I just want willing suspension of disbelief, good plot, and good gameplay.
I'd go so far as to say there is an uncanny valley for realism. Now, before I begin, I'd like to say in all things this is a case where Your Mileage May Vary. What a person finds unappealing do to its "realism" or lack thereof is entirely idiosyncratic. My opinions about what is in the "realism uncanny valley" are valid only for me. The idea I'm stressing is that I think there -is- a "realism uncanny valley."
If a game tries too hard to be realistic, then it can wind up falling on its ass if someone who is actually familiar with the topic plays it. For example, both Mass Effect and Metal Gear Solid are full of nonsense, but I can buy it from Mass Effect. The MGS series tries to bill itself as a serious work and explain everything away, so suddenly my rational brain starts working. The bio-and-military BS grate my nerves seeing how I'm an ex-combat medic with tours in combat and a currently a med student. Mass Effect focuses on characters and plots, handwaves its silliness, and so I wind up not caring. Yes, the whole mass effect thing is utter rubbish, but I can forgive it more easily. MGS winds up in the realism uncanny valley for me. For me. Let me say it again: your mileage may vary.
Or for a less fan-boy baiting example, consider the old NBA Street games, so over-the-top and cartoony, and then the NBA Live games. The Street games were so successful because they were such wild caricatures, while the Live games shot for ultimate realism. Both succeeded. I think a game in the middle would have failed, as neither casual basketball fans nor hardcore fans would be happy with the compromise.
Again, your mileage may vary.