I never have on Google Search (I also block them to be fair), but I've booked a lot of shows through Instagram ads actually. Shows I learnt about only through those ads and I would have been disappointed to miss.
But yeah that's literally the only platform where I've ever had useful ads. Even other meta products only have absolute garbage ads.