I've never seen this issue in 15 years of Mac OS X/macOS use. Is this via the browser (which?) or the command line or some other tool? When I download something, it shows up in the filesystem immediately, or as near to it as to be "immediately" in human terms.