Honestly I don't have hope for anything produced these days. Hollywood seems so obsessed with injecting woke political statements into everything instead of putting storytelling first.
And if Discovery is canon for Strange New Worlds, they've damaged the character of Spock in my opinion. Anyway, let's hope I'm completely wrong and it has the spirit of Treks gone by.
And even if it has the TOS / TNG spirit, the fates of Spock, Pike, and any other TOS characters are known. Spock can't die in this time period so can never really be put in jeopardy. Pike has to end up in that mobile box. So if someone has a knife to his throat, you know he's getting out of it. Only original characters or those with unwritten outcomes can truly be in danger.
Again, forgive my negativity and let's hope I'm very very wrong.