MyUXG Max has DHCP, and for my attached devices if I specify a static IP I get the option to set a Local DNS record.

There's no central management of these records that I'm aware of though.

Absolutely love my Unifi setup, recently upgraded my USG to the UXG as the old was EOL and not performant enough for gigabit routing with SPI.

Not with ipv6