Read Mishima's sea of fertility series then. It's pretty good man.
Dune is also kind of like this, but I thought the quality of the books dropped off really fast.
Many of the Icelandic sagas have some element of multi generational story telling. Some more than others.
The Greek canon is similar, but the multi generational element is usual separated into different more isolated stories.
Other than that watch Jojo.
Those detective stories I can't ever find anything like. Maybe just read the ST books about Garak though.
>>4767
I Claudius was really good. Claudius the god was trash. Julian by Gore Vidal (Don't really like Vidal,but if I could time travel I'd fuck all his bad opinions out of him) was pretty good in the same vein.