I remember reading them back in the early 90s (Robin Hood: Prince of Thieves, Far and Away, Back to the Future). They don’t seem to be a thing anymore (or am I just not noticing them).
As an aside I remember liking them but I was a preteen at the time so maybe they were terrible and I just liked the movies.
The most recent one I’ve heard of was Once Upon A Time in Hollywood.
I think novelizations have the potential to be cool, but the few that I have read felt kind of soulless. They just describe what was on the screen.
The OUATIH novelization was cool because it looked at the story from different angels. Felt less like a novelization to me than an alternative view.