For history try: Hotel Dusk, Phoenix Wright, Super Paper Mario, Fatal Frame (one of my favorites), Dragon Quest VIII, Chrono Trigger, Max Payne, Bully, Indigo Prophecy, Kingdom Hearts (only the first game), Zone of Enders, Monkey Island and Day of Tentacle.
I covered almost all genres and audiences with this list. That does not mean I think they are all great. If you do not like even one of these games stories, then just give up. You can not expect scenario writers to be as good as novelists and all time classic writers.
Satan said:
"You are for ever angry, all you care about is intelligence, but I repeat again that I would give away all this superstellar life, all the ranks and honours, simply to be transformed into the soul of a merchant's wife weighing eighteen stone and set candles at God's shrine."