Where are files located?

I am moving from Pop OS to Zorin and am still newish to linux in general.

In general, where are .deb files located, both configuration files and executable files (I know these are in different locations). I used to be able to find .deb configuration files in

/home/<user name>/.config/

but that is only displaying 2 out of many I have installed. Yes, I have checked "show hidden files."

The same is true for flatpak which I used to find configuration files in

/home/<user name>/.var/app/

and executable files in either
/var/lib/flatpak/exports/bin/
home/.local/share/flatpak/exports/bin/

and again it is only showing 1 out of many I have installed.

Seems like this should be related to a setting to unlock viewing of these files but "show hidden files" is not unlocking it. Any suggestions on how to view these files or if they are in a different location?

Often, the user configuration files are created only after settings have been changed in the apps. When you use the default settings, the apps may not appear there.

To me, it is not quite clear what you're looking for.
It can help to search for the appname in the search of the file manager to find all files with that name on the system.

The binaries of .deb packages are saved at /usr/bin or /usr/local/bin, the .desktop files at /usr/share/applications or ~/.local/share/applications, the user's configurations at ~ or ~/.config.

To show the hidden files hold control key and press h to show them and again to rehide them