True heroic fantasy book

Hello !
I am looking for a true heroic fantasy book.
To me a true heroic fantasy book is a story that spans across many volumes, many important characters and places. With a story that make sense, details from first books that are revealed in the last.
Mostly in a medieval setting, magic etc…
But even magic that makes sense and not "it is something that works somehow"

The best exemple of this is Sword of Truth from Terry Goodkind. The magic at the end is nearly scientific and makes complete sense, you follow different characters at different times, the plot continues and some stuff done in first book has impact way after etc… It is also very adult with sex, gore and not all smoothed for teenager.

So : do you know any book like Sword of Truth ?
Thanks !