Since I'm oriented to external (portable) drives, I always keep image files on external drives, and catalog files with the images on those external drives. My catalog is therefore entirely portable, and I could open my catalog(s) at your house, on your system, and it would like much as it looks at my house. We use Mac machines, and find OWC FW800 drives a good value. I buy the 1TB "pocket" drives which are buss-powered to carry in my laptop bag. For our main in-office system, we use the OWC Mercury Elite enclosures in larger sizes. On the boot drives on my system are SSD.
Using SSD, RAID or otherwise, for image storage is something I'd find unusable. But it depends very much on how much data we're talking about. Some very disciplined shooters, who log a few dozen images a week, might find it more than practical.
John Caldwell