I use a personal password manager and the database is protected by a password and you have to provide a key file. To select the key file you click a file selection dropdown. A Finder window pops up and opens the folder I previously navigated to with this file dropdown and presents you the folder where I stored the key file. In terms of security, you understand this is not desirable behaviour.
Ideally I would want Finder to just open the default folder that pops up when I open a new Finder window. I would like to modify this behaviour for this specific application, but a system wide solution is also welcome. I don't mind clicking through several folders.
I am on a relatively fresh install of MacOS High Sierra 10.13.4 and I'm not afraid of tinkering with the Terminal or AppleScript. I just don't know where to start.