The Summer and the Winter sales are the big ones. Winter is in late December. Autumn sale is still cool though. Steam sales in general are destroyers of wallets.

Humble bundle is also a great source. Every few days a bundle gets replaced with a new one and they pretty much always come with keys that you can redeem in your steam account.