You can probably figure out the general class of storage you need / can afford, which is interface and bits per cell, but then you probably need to try several well regarded drives (or several dodgy drives, if that's what you can afford) to see how they work for you. Or just go with whatever your hosting provider can supply ;)
They belong in a desktop/gaming machine not in a production web server.
Here is an old review with enterprise drives and the Samsung 840 pro consumer drive which received excellent reviews at the time it was released, notice how it is the worst performer over time. https://www.storagereview.com/micron_m500dc_enterprise_ssd_r...
The exception is Optane 900p which is blazing fast! A gamechanger!