No, it doesn't matter if you use AF or SP, get whichever is cheapest. The fins aren't dense enough to make any bigger difference than a degree or two. Corsair introduced this crap, it's just marketing bs, that unfortunately people really take seriously. All fans aimed at the consumer PC building 'community' work universally, same screws, etc.
We can't suggest a different cooler, because you haven't told us what CPU you're using, case, or ambient temperature. Chances are, an air cooler is going to be cheaper, lower temperatures, and quieter.
All the best!