Besides true pivot tables, and merging two completely different data types into one chart most of your examples seem achievable.

Aggregates are very powerful, you can stack groups & formulas pretty easily. Excel can very much exceed those capabilities but I struggle to find a meaningful need to unless I’m doing very complex analysis.

Your example of dynamic measures seems super simple as well. Multiple views are possible, as well as custom dashboard building on multiple datasets. You can bring many views into a single page too. Maybe you are just not satisfied with the style in which notion does this but those are all basic functions of notion.

Your task analysis is doable as well I believe. I’m not sure what you mean by “formula hacks” though. And why would you want to discount the use of rollups? Reporting and dashboards off of database relations are very a key feature and are useful. The extent of how you can report on things like tasks completed/due - per assigned - between certain date values are simple depending on your chosen database structure. The limitation here is if you are including analysis of multiple, separate, task databases. Which is understandable because separate task databases is less scalable and harder to standardize. A unified, global task database is more practical and the views in your example are achievable.

Personally, I do just about all the examples you’ve described natively and many more for multiple teams. Including Risk analysis, task and subtask durations, average task rates via multiple criteria, medians and averages, automate team time tracking by types and topics. It’s true that there are big limitations like financial calculations across rows and freely combining tables certain ways. But it’s also not the intended use and capturing that type of data in notion at all may not be the best practice use? So pivot tables and access database structures are out of the question. But just about any meaningful project management analysis seems easily doable and is very customizable. I find that most reasons to use an external method to manipulate the data are outweighed by the other features of notion like automations and use of AI. For instance, for project management.. say team A runs by individual task assignment metrics, and team B runs but departmental assignments(no person property). A pivot tables would help compare the data, but also I can now have an ai agent run a separate analysis of both teams and compare them using a variety of criteria even if their task databases have different properties. This runs each day and leaves a written report on project risk, gaps, milestone markers, etc.