Following up on this thread in the chat and my own post here in the forum (which is closed).
I did some more digging and came across these two:
- A lengthy and insightful blog post by Chickensoft about display scaling on macOS and Windows and their Godot package that deals with it.
- A rust crate that deals with display scaling on Linux, macOS and Windows.