I put up with Numbers awful pivot table mechanics (why do they have to be manually updated?) because it genuinely allows you to create nice information displays with your tables.
I have a numbers file for my personal finances and it is so nice having some tables at the top with mortgage info and then details below. It makes running what-ifs super easy. Charts in excel and GSheets just kinda float over your content awkwardly.