Finder is indeed frustrating. "Recent" seems like an attempt to fix this without the need to use some giant camera roll?
The (hard) problem is that almost every finder alternative/add-on I've tried is someone else's ideal workflow that still doesn't sit well with me. I find KDE's Dolphin similarly frustrating - for very similar reasons.
Both work marginally better (for me) when used in concert with the quick-find tools like Alfred (or Spotlight) and KRunner. None of these are perfect.
Showerthought: maybe the "find files" interfaces aren't the worst offenders; maybe it's the "place files" workflows that are problematic and we're trying to solve the wrong problem?
[dead]
If only recent actually worked. I see no rhyme or reason why something gets in recent. I guess finder has to be involved. So often I am working with files between apps, saving and opening and such and the files never appear in recent which defeats the purpose for me.
And then we have the spotlight deamon processes which seem to exist only to burn earth's precious resources.
But when it works it works great. ymmv