The RS guidebooks and TV episodes cover several Rothschild museums and homes and home museums and museum homes around Europe but I don't think Rick ever gives an overview of the Rothschilds's historical arc.
A 2021 documentary, about 50 minutes, by a German production company, offers a mildly dramatized thumbnail of their story, from Frankfurt to New England and everywhere inbetween. It focuses especially on how Dame Miriam Louisa Rothschild and the journalist William Shirer helped get many children out of Austria in the late '30s, while they were in negotiations over getting Vienna office head Lionel released from solitary confinement under the Nazis. They eventually settled on a huge tax/bribe and the sale of one of the family-owned metalworks, which the reich never actually paid for.
The film is streaming for free on Roku and some other services, rentable from Prime, and is even posted on YouTube, but for Pete's sake please don't watch it on YouTube so you can spare yourself the anti-semitic conspiracy rants in the comments section. That family was no less nor no more corrupt and self-dealing than any other robber barons of their day, which means that they were less malevolent and more charitable than many of the robber barons of our own day.
A tidbit that I was not aware of before watching this film: as cosmopolitan and internationalist and nouveau riche as the Rothschilds were, their sympathies still lay with Austria and the Rhineland: they sided with Metternich against Napoleon, and helped the germanic nobility get around France's attempts at sanctions and account-freezing. The family made tons of money off of government bonds (literally tons, moving gold reserves under the French trade barriers), but this kept the Austro-Hungarians afloat long enough to wait until Napoleon burnt out (or froze).
https://metafilm.at/en/film/the-rothschilds/
Does this history make Frankfurt rise to a higher spot on your list of places to see in Germany?