"Open folder in new window" for Finder?
Just hold down the Command key (Cmd) while double clicking the folder and it will open in a new Finder Tab.

In Finder Preferences, you can specify to open in a new window instead of a tab.