I feel like each TNG character was individually introduced by turning to the camera to reveal their face, cutting to a low angle, and grinning while they repeat their old catchphrase, possibly with a pause to let the live studio audience applaud. That didn't actually happen, though, it's only Worf who did that. And when a character is coming back to television for the first time in twenty odd years, it's almost the only way to handle things; there is a degree of special guest star treatment that's warranted. But it's inherently trading a lot on nostalgia, too. I don't think you can really separate those things. Making this show without that attitude, without accommodating the audience's desire to see where all their old favorites ended up and see how they're all going to get dragged along into this new adventure, would probably make for a show that felt uncanny and foreign and as if twenty years of change really had happened while we weren't looking, and Picard already tried that in the first season. S3 is what everyone wanted all along, after all.
But, you know, the mystery starts with Picard's TNG uniform box for a reason. And as uh, brilliantly delivered as the Moriarty fakeout was, it would be properly incoherent without the nostalgia decoder glasses. Again, it's the things that are funny in Lower Decks because of how on the nose they are that make this show feel so deceptively cozy to me. Discovery S3 gave us that one big "I am the Guardian of Forever", Picard tries to give us at least one per episode. Maybe Picard S1 really is what you get when you overcompensate to avoid that feeling, and there is no middle ground, I don't know. And Lower Decks is just the other model that's handy for comparison, I don't think this is a domain that comedy is exclusively equipped to navigate. But I do know that how Picard S3 negotiates nostalgia is inseparable from everything else that it's doing. It's all extremely subjective stuff, but there's a lot of it around.
As for Raffi ... it's less her character and more the fact that the universe will not let her catch a break. Her situation when she's reintroduced is that everyone she knows is gaslighting her into thinking she's a paranoid basket case again while she follows the threads of another equally real Federation-threatening conspiracy. She feigns being more or less drunk in a gutter before revealing that she's Starfleet Intelligence, and then we gradually find out that everything else she said about herself like her breakup, family problems, and desperate need to show Starfleet they should take her seriously are all true; she isn't really strung out on drugs, but the plot is going to require her to shoot up later on for no reason just to clear the bingo card. And this isn't anything new, as every season has singled her out to suffer special in some way, but she got some good time in S2 just being capable and cool and a mutual foil with Seven, and I miss it here.
The Worf mentorship thing is fine I guess? I would feel a lot better about it if they'd dropped it on us in her first appearance in media res. The whole conceit of Starfleet and Worf communicating to her through anonymous text messages and her having to use her own hand-me-down starship instead of getting a company car, just really pushing for us to understand how isolated she is in all of this, it was completely unnecessary. Extract all the nonsense with Starfleet seeming to construct a mission precisely to drive her insane and what you have left is pretty good. Worf's feel-good reveal to save the day and Raffi insisting she totally had that guy (she totally didn't) should have been in the first scene we had with her, a scene that they could have held off to the second or third episode if necessary. She could already be the slightly annoyed mentee quoting Worf's anger management techniques back to him like a sarcastic teenager from go. And then we'd get to skip all that exposition about how Worf got wiser in his old age, too. (Because, you know, I can't imagine if the show had left us to work out for ourselves that tea-sipping samurai Worf with anger management mantras had to do with offscreen character development, how would we ever figure that out without suspiciously pertinent exposition covering exactly the last twenty years we didn't know about.)