Leopard's dock is dissapointing to me, and in my opinion, Stacks are incredibly useless, so I set out to find a way to make folders in the Dock open in a Finder window. Here's how to do it:

  1. Create an alias of the folder you want to put in the Dock.
  2. Drag that alias to the Dock and now when you click on it, the folder opens in a Finder window.
  3. (Optional) Put your Dock aliases in a folder, and put that folder somewhere (I put mine on the root of my hard disk).