We have build Emvi[1] to solve many of the problems when it comes to managing a long living personal or teams knowledge base. The idea is, just as you describe in your blog post with notions tables, that if you can remember a fraction of the information you're looking for, you can find it using text search, filters and sorting. A fixed structure won't cut it when you have to maintain it for a long time and I believe it's better to add meta data (like tags) to make it searchable. Emvi has a free tier with way higher limits than notion, so that should work for most personal knowledge bases.

[1] https://emvi.com