Cabaret is brilliant and IMO can’t really be bracketed with the average musical.
I was about 16 when The Sound of Music first came to the cinema (I am fairly ancient) and within no time there were old ladies on the news going to see it for the 47th time and saying, ‘Aaw, it’s luuuvly!’
Cringe! Quite enough to put me off it for life!
Except that roll on about 15 years, we were living abroad with nothing on TV and (then) hardly any videos available, when someone gave me a pirate copy of the S of M, saying that dd1 (then 3) might like it.
So of course I watched it with her, and when dh came home said somewhat sheepishly, ‘It’s actually rather good.’
Dd (now with 3 of her own) has been an addict ever since and her own dcs love it, too.
I’ve thoroughly enjoyed Buddy on stage (I certainly wouldn’t have chosen to go but invited by a friend whose birthday it was).
For same reasons saw Lion King, which I found pretty rubbish, or at least much more suited to children.
I love the old Rodgers and Hammersteins (Oklahoma, South Pacific etc.) because of so many memorable songs, and from that POV very few have IMO matched up since.
Only one song in Les Mis struck me as at all catchy or memorable - Master of the House - which was IMO brilliant, but as for the rest.....
I wouldn’t condemn them all, far from it, but I know people who would, especially one self-proclaimed intellectual (to be fair he does fit the description) who would never watch any of them on principle.