What happens if you use the wrong oil for an oil change?

With the plethora of oils available it’s not uncommon to use the wrong oil for an oil change. But the consequences may be found in unexplained equipment failure you’ve had: Has the question “I wonder if this is the right oil” ever been asked? If so you know exactly what we’re talking about.