[DS]

You can find it under /Users/<username>/Library/Application Support/Steam.

If you're using Lion (10.7) though, the Library folder is hidden.

You can unhide this folder by running the following command in Terminal:
chflags nohidden ~/Library

OR

Open Finder's "Go" menu, hold the Option key and click the entry for Library.