My clearest memory of that was me as a kid watching a Bond-movie where a sportscar makes a screaching sound when driving down a sandy beach. I turned of the TV and don't think I ever saw a full Bond movie after that.
The list on the page you linked had one thing that isn't toally correct though:
>The very specific (but entirely unrealistic) echoing thud that is heard when all the lights are turned on in a large spacenote .
That sound is realistic if it is an old building with the heavy type of power relays or whatever they are called. They do make that sort of sound if the acoustics are right. They could be set up with timers so they don't start the lights at exactly the same moment to prevent overloading the fuses.
Surprisingly, it’s also present in live sports, see for example this article (in Finnish) about sounds in winter sports broadcasts: https://yle.fi/aihe/a/20-10005843
I'm having problems watching movies at all, there is so many things breaking my immersion. :-)