SOLVED - So here is how this played out in case someone else runs into the same thing.
I brought the car to a different dealer. The service adviser there was like "yep, you need 4 new door lock actuators (2 fronts and 2 sliding side doors), we see this all the time, in fact I own a 2010 connect and just bit the bullet and did all four on mine and it solved the issue" So I do not understand why the issue presents as intermittent but there you go. I went ahead and had them replace the 4 actuators to the tune of $2000 parts and labor and everything is working well again and it has been 3 weeks since completed.
Hope this helps someone in the future.