I'd rather the show not become a nostalgia for nostalgia's sake driven check-list of cameos. And is able to actually focus on building the new crew, making them interesting and establishing some strong new direction, dynamic and relationships for Picard.
I too hope it's something new and refreshing, rather than a reason to just bring back all the old characters. That said, a show set post TNG but with Picard at the helm ... there's a certain amount of nostalgia there that's going to play off with the guest appearances and cameos.
It might not be season one, but I'd surprised if we didn't get something from Kate as Janeway (she is, or at least was an admiral), and considering her journey home, in addition to her Federation values, you wonder whether she'd be likely to side with Picard or not.
Throughout Trek there's always been characters I wished had met on-screen; the likes of Worf and B'lanna for example, or Ro Laren and Kira, or even Chakotay/B'lanna and Garak.
Somewhat upends Roddenbbery's vision of the future, or at least what Starfleet and the Federation of Planets could embody in a future. Curious to see how Picard (and the show) navigate that?
Roddenberry's vision has changed over the years already though, DS9 did that when it introduced a war, if it wasn't touched on before. Roddenberry's Trek would never be realistic.
I think it's important also to note that the Federation of TNG/DS9/VOY is different to the Federation of DSC & TOS. I can't remember the exact speech, but Janeway says as much to someone in one of the earlier VOY episodes, something about how the likes of Kirk, Spock and McCoy were a different breed of officer.
It stands to reason that breeds of officer change over time within the Federation - just has officers and the military has adapted and evolved in reality. What I'm truly intrigued by is whether the Picard show and this
different Federation ultimately leads into Discovery's Season 3. I'm wondering whether whatever changes the Federation is going through in the Picard series eventually leads either to it's destruction, or it's disassembly, thus when the Discovery ends up in the 32nd Century, and there is no Federation (from what little we know) the initiation of why that is starts with the Picard show.