Earlier quoted context omitted.
macOS has a folder called Library where this stuff is supposed to go. It's not enforced by decree, with many apps doing their own horrible thing. Ultimately, its macOS' culture that mostly makes apps puts their settings and other resident details in Library. I'm not knowledgeable enough to know why a culturally enforced folder is far worse than the database that Windows has. Care to enlighten me?
I pressume "Program Files" or "AppData" folders are Windows analogy to Library
"ProgramData" is like /Library.
"Program Files" is like /Applications.