Any external drive works fine but spinners need a separate power supply.
Nowadays there is no reason not to use SSDs Smaller, faster and USB bus powered.
I wouldn’t know about Roon but if it only likes DLNA via NAS then that’s another reason to avoid it. I sold my NAS, not looking back.
If the network drops its handshake the NAS disconnects. Phooey.
dbPoweramp is my choice for ripping. Flac all the way. I tried alac but it doesn't sort for shit in Windows. Flac is universal.