I have German Palatinate ancestors too! They were Mennonites.
I think all my ancestors were pretty cool. I have no major claims to fame like royalty. There was a rumor that my maternal grandmother's ancestors were related to Dutch royalty but I have found nothing to prove that. Another claim on my paternal grandfather's side was that we are related to the man Pike's Peak was named after but again, nothing.
Most of my ancestors were simple farmers or sailors yet I find them so fascinating, I'm not conflicted about any of them. They have definitely influenced some of the non-fiction I read. I read several books on the Pennsylvania "Dutch" (Germans), the Palatinate immigrants, Mennonites and histories of the areas they settled in. I also read a biography on William Penn since he was the man responsible for the settlement of so many Pennsylvania "Dutch". It all helps me understand my ancestors so much better by understanding their world and their culture.
If I were a writer, I would totally write about my ancestors. I would love to write a love story about my 3rd great grandparents based on the love letters they wrote each other in 1837 which still survive today. I've started to do research on it but I highly doubt I'd ever be able to actually write something. Still, the research is fun and helps me understand them.
I also have a bunch of books on my to-read list (I have a whole shelf on Goodreads called "ancestry research") on the daily lives of people from different time periods and locations. The only thing I can't abide is war and military books - I don't care that I had ancestors who fought in the civil war, I'm not reading a military book on the civil war. Now, I could read a book on what life was like for soldiers in the civil war - from the human side. But military history bores me to tears.
I do have ancestors who came into a lot of money when their wealthy but childless and unmarried uncle died (which is a bit of a mystery in itself - why did he never marry?). But they were unwise with it, never invested and just spent it all. By the time they died, there was nothing left for their children or grandchildren to inherit. Figures.
Oh yeah, just a reminder, I am actually American - don't be fooled by my location.