VirtualLarry-- my first SSD experience was with a 30GB Vertex (first-Gen), and my experience largely paralleled yours. I did a comparison between a 150GB VR (same machine), and asked a few colleagues to do a blind compare/contrast. Neither they nor I could perceive a difference, and I actually sold the drive.
I gave SSDs another shot a few months later-- an Intel G1 1.8" drive, and the experience was quite different. Since then, I've migrated almost every system I have to SSDs, and stuck with Intel for reliability. I still have two first-gen 60GB Agility drives that I use for VMs, but Intel's reliability and consistency have kept me loyal.
I agree that SSDs are not an absolute necessity in general, but can be a tremendous upgrade for certain people-- and certainly a worthwhile upgrade for almost all, price aside.
For the OP, Adobe CS programs love RAM, but an SSD will help. I routinely work on (CS5) Illustrator at 2560x1600, while running a few VMs in the background (SSDs absolutely rock for VMs, BTW), various Office apps, PS, InDesign, Bridge, and a bunch of browser windows. I have a Q9300 with 12GB of RAM and a 160GB Intel 320 with W7 x64. The SSD shines when I have to launch and open various files-- with an HDD, I might think twice about opening up PS to check on a source file, since the wait would be a serious interruption to my workflow. With an SSD, I just do it. Over time, your workflow changes subtly, and that's when the lack of an SSD is painful.