SoundMiner and Basehead are indeed expensive for amateurs I think. And Audio Finder is Mac only.Also maybe worthwhile thinking about how people work with sound libraries. Once you collect up & start to build your own sound library it soon becomes impractical to access & search it via a DAWs sound import browser.
Most pro sound designers used Sound Miner or Basehead, which eg prescan folders & hard drives, building databases in the process and use a built in thesaurus, so searching for 'explosion' will also find 'bang' 'bomb' etc... They also allow you to spot directly to the timeline of your DAW, and do processing during transfer.
Sound Library audio should have metadata fields embedded in them, with more description, category tags etc... These library apps let you search those terms as well... While SoundMiner & Basehead may be too expensive for hobbyists etc there are also affordable alternatives that do a great job, Iced Audio AudioFinder would be a great example of this:
I think the free ADSR Sample Manager is quite useful for auditioning sounds and a certain amount of searching. It does show metadata. Obviously not on the level of the pro tools, but the price is right.
I like BOOM's Soundweaver, and will talk about it in a future video. It's a bit more expensive than the cheaper version of Basehead, but I like that it has a lot of easy to use features for stacking sounds. Sonokinetic's Ibrido Zero is also a nice tool for experimenting and combining samples after you have them.