I'm a HUGE fan of iWork, but Numbers is really a "miss" in the user experience dept. Pages has a streamlined way for creating medium to advanced formatted documents. It (and Booklet Creator) will be the apps I miss the most when my departure from Mac OS is complete.It’s not for me either. But for the casual user maybe.
Keynote is the same for presentations and even for creating illustrations. But Numbers, in its attempt to hold the user's hand, created a workflow that is way too clunky.
I heavily use iWork, Google Docs, LibreOffice, and MS Office daily. Except for Excel, I do not enjoy using MS Office.