Is it preferable to have a Save As modal dialog, or to just automatically save with a default name?

I noticed that clicking the "Download" option/button in Google Drive, Slack, etc. doesn't prompt the user for where they want to save, and with what filename. It just goes to my "Downloads" folder with a default name. Is that standard?