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.
Keep in mind that Black Friday and Cyber Monday just happened.