First off, today in the shack I got the radio working after a lot of reading and video watching. Programing the radio was by far the most challenging learning curve for me, building and configuring the hotspot was child's play by comparison.
I got both the TG310997 and TG9990 parrots to play back my test transmission. However when I was going through and joining talk groups I was hearing nothing. I started to wonder if there was a problem. I opened WPSD dashboard in a web browser and I could see my RF into the hotspot and the TGs I had activated. It wasn't until I kurchunked the TG93 North America group that a station saw my call and decided to call me (I was actually surprised to hear my call). I responded and we had a brief chat, he said I sound loud and clear at his QTH in TN. I did not ask if he was connected via a repeater or hotspot.
Now Todd as to your question, yes via the hotspot I can access any talk group that my local repeater might be hosting, with one exception being a local TG that is not forwarded to the network.
My local repeater N1WW (the DNR machine, they also have a separate FM/YSF machine) has a local talk group listed for TG9. They are on the DMR-MARC network so I guess that number is available for local only TG, however on the BrandMeister network it would be a technical issue.
There is an article about this here...
[URL unfurl="true"]https://news.brandmeister.network/brandmeister-dmr-repeater-sysops-how-to-create-a-local-talkgroup-on-your-repeater/[/URL]
If you look at the NEDECN page for N1WW you will see in Time Slot 1 they host access to 14 talk groups dynamically, meaning they must be brought up by a repeater user and will disconnect without activity after a set time.
In Time Slot 2 they host 2 talk groups that appear to be static, the static local TG9 I mentioned above, and also dynamically TG8802 NE TAC2.
[URL unfurl="true"]https://nedecn.org/home/repeaters/massachusetts-repeaters/gardner-n1ww/[/URL]
Keep in mind everything I have said above is my interpretation of what I am learning, and could be terrible wrong.
[USER=29151]@ToddDubya[/USER] I suspect I will be able to ask you questions about this a month from now, because I know the power of learning something new will draw you in Todd. 

P.S.> I was also able to bring up the N1WW 2m analog FM machine direct with the cheap stock antenna on the DM-1701, so that was cool although I do not know if I would be able to achieve full quieting in a conversation.