Just like I do with USB cards, I'd recommend getting a card that uses a chipset supported by native drivers in MacOS. That way you aren't relying on third parties to update their drivers for every new version of MacOS, which they will inevitably give up on, and it sounds like that's what happened to you.
IIRC, any eSATA card with ASM1061 chipset should work. There are a dozen on Amazon for $15-$30. Make sure you buy one from a place with good return policy just in case my information is out of date.
Keep in mind that all of the cheap cards only support basic use, as is typical for running a hard drive or SSD. If you need anything fancy like port multipliers or RAID or whatever, you're probably going to need one of the more expensive fully featured cards.