Usually says so in the system requirements. If you go to Spec Ops: The Line's product page, for instance, you'll see that it requires Steam activation -- final line of the system requirements. You're basically purchasing a Steam retail code in that case.

Payday the heist is also $4.99 there Spec Ops: The Line $24.99

But why consider using Amazon when Steam exists?