To me, the biggest benefit SSD gives is battery life. I like that it's quieter too. But neither of those is worth the price premium. Which is why I haven't stepped up for my home machine even though I get to compare it on a daily basis.
The biggest bang for the buck comes in the form of added RAM, which augments the kernel's buffer cache on any modern OS. Many of us rarely shut down our hosts (perhaps to update the kernel, but that's about it) so we rarely have a cold buffer cache.
For the average desktop/laptop user, unless your memory usage patterns involve allocating massive heap sizes for fun and profit, or grepping through every file in your filesystem, it's extremely likely that any application you launched or document you opened in the past few days is already in the kernel's buffer cache. And the buffer cache is much faster than any SSD.
And besides, if I booted over to Windows 7, it'd take about 4 minutes until this machine was usable, so it's all a matter of perspective.
EDIT: to be fair I just measured Windows 7 and it took 1:30 before the machine was usable.
A 7200 RPM drive is absolutely not comparable.
If you need the storage of a spinner and can't afford a big enough SSD, running a small SSD for the system/apps with a 7200 RPM as a storage drive in the place of the optical drive works pretty well. Look for the cheaper versions of the OptiBay (which is a bit of a ripoff).