You cannot connect a SAS HDD to a SATA port with any sort of cable. You need to install a SAS controller card into your computer, and consumer PCs and Macs don't normally have those.
The reason you see so many SAS refurbished drives for so cheap is that people like you mistakenly buy them and discover they can't make them work on their computers, so they return them or try to fob them off on eBay and the like.
Funny enough I bought a SATA drive from an e-tailer new as a spare and when I went to open it up months later realized that they had mistakenly shipped me a SAS drive of the same capacity (18TB). So it’s well beyond the return / exchange period despite the shipping error. I have equipment to run it but it kind of threw a fork in my plans because I was going to get rid of said equipment. All for that $300 spare drive.