One thing that people don't really think about when it comes to raw files in Lightroom is that once the raw file is imported into the catalog and the 1:1 previews are rendered, the original file isn't accessed any more unless that preview needs to be re-rendered. Let me clarify that, when dealing with raw files this is true since any changes are written to an XMP sidecar file. So a fusion drive setup is fine for this because eventually the photos will be pushed out of the SSD onto the 1TB drive and they don't need to be accessed anymore. The other thing too is that its not the whole file that gets left/brought back on the SSD, its done at the block level. Only the most accessed blocks are on the SSD. Even if you have 10,000 photos, the most accessed blocks of those photos are being left on the SSD which might in all actuality only be 10GB.
More likely the case is the majority of your catalog and preview files would stay on the SSD, which depending on the size of those might be closer to maxing out the SSD part of the Fusion Drive.
If you're figuring that your photo library will max out the whole fusion setup and not leave any room for future pictures and you want to keep everything in one spot, my recommendation would be to look at a TB or USB external drive with mechanical drives to store all your photos on and have either a SSD or Fusion Drive internal drive and keep your catalog and preview file on that.
The only benefit I see of spending the extra money on an external SSD is if you wanted to use that as a temporary place to import all photos onto in Lightroom which could help speed up the import process so you can start working on them sooner and then move them using Lightroom to your main library location. Depending on how many pictures you take between importing them into Lightroom this could be done right on your main drive without need for an external drive assuming your main internal drive is a SSD or Fusion Drive.
All in all, the upgrade of the quad processor and memory are going to make the most impact to Lightroom, with having a SSD or Fusion drive as the main drive as a minor overall impact.
In case you are wondering, I've got a mac mini 2.6 quad with 16Gb of ram and Fusion Drive. I've worked on some 2+GB tiff files in Lightroom 4 and have no issue at all with them, everything is smooth on my 27" NEC monitor. I have yet to try Photoshop CS6 on the mini. My 2010 MBP hated me for using the content aware patch on those same 2+GB tiff files but I don't think I'll have any issue with the mini with them.