Because I am constantly forgetting this Finder shortcut, here it is:

To open a folder in a new window, use "Command - double click" on the folder.