You are right that a spreadsheet gets more information on the screen, but Trello's kanban layout really highlights which task is "where" (in what state).

I've often used it with clients to let them know which high-level features are in progress, which are done, etc. It has also worked really well for collaborative trip planning. Both of these workflows benefit from cards with cover images too.

It's not a replacement for a company-wide knowledge base or an issue tracker for hundreds of tickets.