Aggregations by row/column in board view would likely cover many of the situations I’m thinking of.
My only issue with aggregations on table view is that they can’t be filtered. Here’s a request I made a few weeks back about it: Allow specific databases to be excluded from column calculations
I usually default to formula improvements being an ideal solution because the more they get improved the more flexibility and autonomy all your users have to customize their workspaces themselves without waiting/relying on specific feature requests that might never be prioritized. 