I have mentioned the Quinn’s Ideas Youtube channel. Quinn does deep dive videos about many SF novels and series, with Dune, the Three Body Problem, and the Hyperion Cantos being some of his most detailed work. I enjoy his channel a lot.

This video was great. A quick comparison of the Foundation, Dune, and Hyperion settings.

There are many others, of course. The Humanx Commonwealth by Alan Dean Foster, Larry Niven's Known Space, the non-empire fallen setting of the Dumarest of Terra Saga, the CoDominium by Jerry Pournelle... the list goes on.