Most thus far have been fairly terrible, although the original Tomb Raider is probably amongst the best.
I don't think they have have to be sad and nerdy by default, though. A lot of films these days are either adapted from books or older films; there's no reason games can't successfully be used the same way.
Of course, it'd also be nicer if games had better writing in general beyond Us vs Them scenario #56485734892.