I've never really used their search in general, can't comment on it. I feel like most "piece part" searches are pretty terrible. I would just use Digikey and slowly set all the filters you asked for. Every other "pretty" tool (Octopart, SandSquid, SupplyFrame, it goes on and on) still doesn't help me too much with design exploration.
However, I have used their libraries many times over and they are absolutely not terrible. Altium's IPC generator is nice, but that's only for at the office. Personal stuff at home? SnapEDA + Kicad makes my personal projects actual projects and not just lessons in database management. I spent like 20-30% of my time just making symbols and footprints. That's not the actual fun or interesting design work, it's just the boring stuff in between. Very glad SnapEDA gets rid of that tedious step for me.
However, I have used their libraries many times over and they are absolutely not terrible. Altium's IPC generator is nice, but that's only for at the office. Personal stuff at home? SnapEDA + Kicad makes my personal projects actual projects and not just lessons in database management. I spent like 20-30% of my time just making symbols and footprints. That's not the actual fun or interesting design work, it's just the boring stuff in between. Very glad SnapEDA gets rid of that tedious step for me.