Thanks for the feedback Pizzaguy. To first address the questions within your post;
Yes, the console lock switch will lock/unlock both doors and the trunk, and the key fob only causes lights to flash with no lock action
Yes, the door key will only operate the drivers door, no other actions

Thanks for the clarification about door key working through the SKREEM, somewhere I had seen an exhibit indicating it went straight to BCM. That makes more sense in tying in with key fob not working the locks. I will look at the wiring chapter and see if it gives me any leads on the fix. I will also mess with fuses #35 and #37 again, just in case. Hoping to have some time this weekend to mess with it some more. Have to admit, hoping it isn't the SKREEM as I see they aren't available anymore and sending everything off to be rebuilt appears to be only solution - and it is an expensive solution.

I will likely be back in just a few days with an update, and most likely a few more questions. Thanks again.