The "hero dies at the end" is a really old cliche but it isn't used that much anymore. Most fantasy or sci-fi grand adventures end now with the hero surviving but the love interest dying.
Actually, in many of the recent fantasy books, the trend has been darker, "grittier', less mature as they fling rape and death around for cheap emotional responses... this usually means quite a few of the main characters die as well as practically any likeable character period... if you are lucky enough one even exists in most of these horrid worlds popping up.
That is what I liked about Origins... it let you go pretty dark but also let the player steer the story to a brighter side. So, in one run you could have a rather bleak world and another, a much better one. Though even then, it didn't make most characters so damn unlikeable you want the whole world to burn no matter what.
Yeah, loosely, but Dragon Age has never really been on ASoFAI's level when it came to offing characters.
Thank everything possible for that.... at this point, GRRM can't even bother writing a passable story because he is so in love with his cliches of characters either dying horribly or suffering horribly that the books are gaining value as comedic farces in fantasy. They are like c grade horror films that are just hilarious because they hit the cliches so hard. It was a fun twist in the first book or two, but became a tiresome "o come on... get a new trick already" by book four.