Honestly none of these royals have any particular star power (well, Diana did). It's really their titles that make them interesting. Of the current lot, Harry might be the most interesting because of his youthful indiscretions, but even those are regular old youthful indiscretions that are been there, done that for a lot of people. He grew up, he got over the partying, he got married, now he has family drama just like many people have...snooze. Meghan seems nice enough, but really she's just a decent-enough actress who seemed to want to live a regular life. I don't think Harry and Meghan would have Spotify and Netflix deals if Meghan had just married Harry, the guy who lived next door to her in Toronto.
Will's bride definitely overshadows him, however. Like Diana was prettier/more charismatic than Charles, Kate is way way way prettier than Wills, and she has more charisma.