I have been using Notion daily for 3 years. My setup has gone through more iterations than I can count. Here is what I have landed on.
A homepage that shows my priorities for the week. A project database with status, deadline, and next action. A journal database for daily entries. That is basically it.
The key insight was simplicity. Every time I added a new database or relation, I asked myself if it would save me more time than it would cost to maintain. Most features failed that test.
The databases I kept are the ones I check every single day. If I do not check it daily, it does not belong in my setup.
What is the one view or database in your Notion that you could not live without?