~\Downloads is always the first tab in Finder for me and I almost always keep it to show the most recently added files at the top.
The other weirdness is sometimes a file gets updated (think "touch") and it won't change it's order in the list.
Most of the time it works fine. It's like inotify or whatever sometimes doesn't fire.
Attempting to search using Finder insists on bringing up a giant system wide search that indexes content of files, emails, every stupid thing that contains anything like the phrase I looked for.
So imagine I am sharing my screen and I try to just find a simple file and it's spewing the contents of my private emails in front of everyone. So aggravating.
I've set it to search the current folder, you can also configure Finder to reuse the previous search scope.