I agree with everything the OP said about Opening Night. Probably the worst show I have ever seen. As an alternative, I recommend Standing at the Sky’s Edge. A brilliant, relatively-new musical (2023 Oliver winner) unlikely to come to NY but very worth seeing.