I think curated indexes, with associated search, will come back. Yahoo! was before its time. Now we need a human-curated search engine/index that only has verified human generated content. I guess everything goes in cycles.
Problem is that the curated index becomes so valuable that money speaks louder than the quality. As long as the company is on the stock market or is made using VC money, it will result in enshittification: https://pluralistic.net/2023/01/21/potemkin-ai
The only solution I can see is a mom-and-pop site like Craigslist which are owned by a family which don't want to optimize for money as they think they already have more than enough money.