Modern car aren't actually completely on or off when you turn the key, sure. However I've put petrol by mistake in a diesel car twice and didn't ruin anything (but lost some money cleaning the mess up).