I really tried getting into the new shows. I was so excited for Discovery, I even opened a bottle of good wine saved for a special occasion. And then it did not feel like Star Trek at all, it was dark, brutal, disturbing. I finally dropped out after season 2. Lower Decks was ok, but more of a parody than real Star Trek, with weird character choices. Strange New Worlds was interesting at first, but also with characters that did not feel like the professional Star Fleet personal I was used to. Prodigy I haven't even started because I don't really was in the mood up to today.
I'm not excited when I read a headline like this, something that would be unthinkable a few years back. Let's see what they are cranking out, maybe it's something that has the old feeling again, good plots, good characters and that sense of wonder and optimism for example that TNG had. I haven't given up hope.
DIS got a lot better in the later seasons but if you don't like any of the new shows, I doubt it's your cup of tea either. It's sad to hear this since I basically love old and new trek alike but each to their own. Some shows tried to catch the old spirit (like SNW) but you simply can't produce an old episode now. I personally like it best when they explore new topics and new times but hopefully they will make a show for fans like you, too!
The Prodigy crew don't feel like a proper Starfleet crew, and that's because they're literally children. They are 100% kids with the potential and the drive to grow into great Starfleet officers, and the show is fundamentally about that fact.
Strange New Worlds was interesting at first, but also with characters that did not feel like the professional Star Fleet personal I was used to.
SNW is set before TOS; of course they're not going to be as professional as TNG, it was the early days. It compares well with TOS, but still isn't without its flaws (eg musical episode).
Discovery was indeed crap (in my opinion), it's just a modern generic SciFi show with Star Trek branding. Lower Decks is only meant to be a bit of fun fan service, it turns the Starfleet goodie two shoes-ness up to 11, while pulling back on professionalism to turn it into a workplace comedy. I get the feeling you won't like Prodigy either, it's very much child oriented.
However I think you should reconsider your expectations. We're not going to get another TNG 30 years after that show, expecting something the same but new is only going to be disappointing. I'd recommended giving SNW another go, and also maybe catching up with Lower Decks ahead of the SNW crossover episode.
The problem with professionalism is that they are people on a star ship, but they often act childish or like teenagers. TOS was corny at times, but they acted like absolute professionals most of the time. In SNW I missed that, they were often super relaxed with a good joke on their lips in the face of eminent death. Or I remember when they hunt a poor underdeveloped guy through the ship and get him and making jokes after that. That was definitely the "WTF are they doing" moment for me that made it hard to enjoy.