This mostly cleared things up. However I was confused by this, "and only very small currents used for signals should ever cross this".> I would like to share ground for all of these.
You need to share a ground for all of the DC equipment. If you can, run all GND signals along with the power supply wiring to the same power source (DC/DC, AC/DC, Vreg, etc). If you are using multiple DC/DC converters or AC/DC converters, tie all of their grounds at a common point, but keep the power/GND lines running as a pair to each supply to each load. The tie exists simply to make sure everything is at a similar reference, and only very small currents used for signals should ever cross this.
> Additionally I would think I could tie this ground into the mains ground.
Unless you have a very specific reason to, do NOT do this.
I have a Cana kit power supply designed for rpi4. Any power coming from the pi or hat should be coming from this. I planned to have 1 additional 12v power supply. I assume that i plug the additional DC power supply into the 12v header on the Hat. This would be tieing the grounds of both power supplies together.
