Normally the system does not need 512GB. 128GB might be too tight a fit but 250GB ($98 EVO 850) generally are fine, even with 100-150GB of it used for cache and getting lots of writes.
The user does not need to have anything on boot drive except the 10GB or so of ~/Library - everything else goes to your 7.2k drive volume.
Separating user and system still makes sense.
Aperture and Lightroom are two, audio plugin and libraries another, that benefit from SSDs.
Some users have gone with 4 x SSD (500GB because larger means faster nad more IO channels) so as to have one large easy to manage volume, and speed. Cheap today at $200 x 4 plus cost of two Apricorn controllers (~$200?) so just under $1,000
Price on new 2TB blade is around $1500 which is in line with 1TB Apple OEM prices on ebay, cheaper to get 750GB model.
The first OWC 500GB were $1500 if you remember - and SSDs came out in 2008 where 250GB was $600+
Not sure Lightroom etc need 500GB (50% free is fine).
While arrays have downside (backup, installs and such) the lack of Recovery volume is fne and better without, it can be anyplace. And instead of RAID0, JBOD would give you one 750GB volume,
If you are 'new' to array use, experiment. One reason not to use one for backup is more fragile. USB has its own issues, you are using 3rd party controller usiing PCIe slot too for another. Clone only needs to be 1:1 while TimeMachine needs to be 3.5:1 ideally. CCC also will archive a backup.
If you have 9TB (3x3) and 50% full, then I would want 6TB drives, or at least some 4TB unit or two.