I think the app you're looking for is Default Folder X
It does a myriad other things, but clicking in an open Finder window on the desktop will take the dialog to it [even if not visible behind another app or window]
It will 'bookmark' folders, historically or as Favourites & you can set up different sets for different apps & workflows.
Well worth the price imho; I've been using it since before they added the 'X' to the title, in OS 9 & earlier. I consider it one of my 'cannot live without' utilities.
No affiliation, just a long-time happy user.
Copy/paste of their Main Features section...
Access your recent, favorite, and open folders from DFX's toolbar. Hierarchical pop-up menus let you quickly
navigate through folders to get to your files.
Real Time Saving
If you're constantly saving things inside the same folder, DFX can remember that folder for you. Or you can set it
as the default folder for an application so you're in the right folder
from the start.
DFX lets you open up or save to any Finder window with a single click. It also lets you get info on, duplicate,
rename, and delete existing files, putting the Finder's power in every
Open and Save dialog.
To help you quickly return to folders and files you've used recently, DFX remembers them for you. It even re-selects
the last file you opened. With DFX, you'll never forget where you put
At Your Fingertips
Get places fast by using keyboard shortcuts for your favorite folders. Or jump to recent folders and open Finder
windows with a keystroke. DFX's shortcuts are completely
Spotlight on the Spot
Tag your files or edit your Spotlight comments from within any Open or Save dialog. Don't remember what tags
you used before? DFX shows you all of your recently used tags - just
drag and drop.