I'm thinking of the middle-sized use cases. A table with couple hundred to couple thousand rows. Small enough that you can load it into Emacs without a performance penalty, but too large to pivot by hand. Personal and freelance business budgeting come to mind.

However, at this point I'm OK with shelling out to external tool for data wrangling.