USB HDD or SSD are fine, and a lot of people use them. I also like the fact that it ia also a backup of your music. I don’t think there is a Drive size limit, but see below.
What you may not know, is if you are buying new then an ND5 XS2 comes with a 3 month trial of Tidal, then £9.99 per month