TBH, I'm not 100% sure, but....I have a nice addition to my 3-ring binder of about 25 pages of GMT900 electrical diagrams and a more comprehensive understanding of this electrical system. most or all, of my ground connections are now very clean.

...

.
No spoiler alert, but in the end, I am very appreciative of everyone's efforts in trying to solve this riddle. My time is one thing and I actually enjoy diving in and trying to figure these things out, but for others to spend their time as well (and of course it's a safe bet that's why we are all here) I greatly appreciate that.
Yeah, and it is so much of an "ahaa" it questions my sanity...lol
May or may not be related, but given the odd resistance readings with regards to the ground wires..who knows. I did some more fumbling through the manuals and found this:
View attachment 484557
I noticed there are 2 ground terminals to the BCM on the light blue connector...Pin # 1 and 5.
@mikez71 You asked back at post #31 if I checked both fuses, I did before you asked and I did again to be sure..fuse #5 (CTSY) and fuse #17 (IS LPS) I also checked fuses # 1, 3, 46, 47, & 52 in the engine bay...anything BCM related...all were good.
Up until yesterday, I have removed and cleaned grounds at the front of the frame, firewall, block, LR near spare tire, both G200 and G201, and I kept coming up with 1 megaohm of resistance from the ground terminal in the overhead console and either G200 or G201 and the clean metal behind the dash, but it changed with modules going to sleep. I also reset the TCM after my trans fluid change, I have removed the NEG cable about 3 times and even last night, I had no map lights.
So I go out today and was going to probe some leads from the BCM and checked the fuses again...
View attachment 484558
Fuse #17 IS LPS in the I/P fuse block.
I've been doing this for a long time, I don't see how I missed this prior to today, I'm 99.99% sure I would have seen that broken jumper....which begs the question, did I miss it. I know I pulled that fuse at least twice and checked it with a LED test light. This is the Helen Griswold moment...lol.
I can't explain the high ohms to ground.
Did reseating all the junction block connectors, wiggling the BCM connectors, removing the NEG terminal a number of times reset anything? That's hard to justify.
If it's not the fuse from the start, do I have any cracked solder joints at the light blue connector in the BCM? One thing that could dismiss that is when the modules went to sleep, I ended up with .4 ohms to ground from the overhead NEG terminal from 700 K ohms...but that took time. Ohms's law says resistance doesn't increase with voltage so I don't know how it would reduce as the modules go to sleep..unless other circuits were involved.
So we shall see, but for now all is working and it's hard to believe it took 5 pages to come to this.