I have a few thoughts.
Do you need access to ALL files or can some be archived on a backup storage device? This may allow you to get an SSD with an external enclosure for only the currently needed photos.
I was fortunate that my photos were on an internal dedicated 512 GB SSD in my last laptop. I am in a situation where I just move to a rMBP with a 256 GB SSD. I cannot keep my entire 250-300 GB photo library on my internal drive.
To resolve this, I recently purchase a USB3 enclosure for my 512GB SSD. I am seeing 500+MB Reads and 400+MB writes from it. BTW, the SSD is a Crucial M4 6GB SATA III drive. This is actually MUCH faster than the performance I saw in my old laptop where it capped at ~250MB Reads and ~200MB writes due to the internal 3GB SATA II connection.
If you go with a Thunderbolt drive, you will be a bit more performance from a 6GB SATA II drive, but not much. I believe I read that USB3 maxes out at 5GB and thunderbolt is 10GB. Granted, you would get the full 6GB capability, but in real world performance, I don't really think it would be noticeable.