OP, generally the results are "expected" and "reported" to be better when using an external storage device (versus the internal one you are considering). The only way to find out is to try the various options within the confines of your own system / setup.
There are advantages to be gained from galvanic isolation and other noise suppression / resonance controls for the external storage device. You lose those options / opportunities by going with your internal ssd - Roon Core iMac (all in one) solution.
Something to consider is to walk away from your iMac as Roon Core and to get a dedicated Roon Core option.
All the best.