Hi Tim, thank you for the pic, and the excellent description of the problem.
The reason the water fills in that pipe actually and ends up down where water does not belong is a leak somewhere in the bottom of the dishwasher itself. When water gets in there it activates a flood switch.
Thats why tilting the machine to remove the water makes the machine work once again.
This one is difficult for you to determine so I have to recommend having a technician look at this one so he can tell you exactly where the water leak is coming from and he can repair that for you. This one isn't a do it yourself project Im afraid.
There is a lot you would need to knwo about this machine in order to fix this one. But... An experienced appliance tech can do this easily;-)
So it shouldn't be an expensive repair at all;-)
I wish I had better news for you Tim, I really do but you need to have this one checked professionally.
In any case, I will stick with you until this is complete.
Please rate my service kindly.
Also it is the only way I am credited for my time and expertise with you.
Once you rate, I will be notified and will add your question to my priority list so you can reach me anytime until this problem is solved.
Then you can reach me by simply replying to this message anytime.
Thank you and have a wonderful SUnday Tim!