This is where things get kind of blurry for me since I can see all of the steps on their website but don't really understand all of the code in their instructions. I am sure that the node could be used for all sorts of queries but I just have no idea how to do all of that...yet.

That's probably the primary reason why I haven't set up a dedicated BTCPay server yet. Maybe this thread will be what lights a fire under my ass.