I think unless you are using the mac solely for websurfing and email you should go for the 2TB fusion at minimum. With 24GB SSD most if not all of that will be taken up by your OS, and the rest will be taken up by the applications you have installed, leaving you 0 SSD for your media files. As you're doing some PS work it just doesn't seem enough for your purposes.
This is a
total misunderstanding of how Fusion works.
Fusion only loads BLOCKS to the SSD - not the entire OS, not entire apps, not entire files, just that code/data that is required. The only parts of the OS that will be on the SSD will be the parts you
use (although, at under 8 GB, even the entire OS would not overwhelm a 24GB SSD). The only parts of your apps that will be loaded, ditto, data, ditto. OS X manages the SSD the way that it manages RAM - it knows what you need, it knows what you use, it knows what hasn't been used lately, and it puts it/leaves it/removes it from fast storage as required.
(Now, the people who insist on splitting their Fusion systems so that they
can put their entire OS and all their apps onto Flash
are doing as you describe - a totally wasteful, overly-simplistic practice, if you ask me.)
One can look at going from 128GB to 24GB to be a downgrade, but I'd look at it as more of an upgrade. Reducing the amount of Flash storage reduces the selling price, making Fusion more affordable as an entry-level feature. Will the performance of a 24GB Fusion system be the same as the 128GB? I can't see how. However, Apple has had several years of field data more than it had when the feature was introduced - whatever the performance hit may be, I suspect for light/moderate use, there will be little or no perceivable difference in performance.
The message to me is pretty simple; the people who need more RAM are likely to need more Flash, and will buy more of both (whether as Fusion or pure Flash). Other people will buy more RAM and Flash than they really need. Others will find that Apple's base configuration works great for their needs.