It would depend on the controller. Most SATA SSDs are already saturating the max throughput of the interface (~600mb/s iirc), so you might want to look for a PCI-based option instead. Even still, I have a hard time imagining the performance squaring up against a proper NVMe drive.
I'm not trying to discourage you or anything, but I think paying $50 for an adapter to run 500gb of RAM slower than a $50 500gb NVMe drive is a bit of a goose chase. Good luck in your search regardless!