How can I open a folder called something.app in various applications?
UPDATE: Recent versions of OS X have removed this ability. The answer below applies to OS X 10.9 or earlier.

A simple right-click of the folder will enable you to view the contents using "Show Package Contents."

If you're trying to access the folder from a Save/Open dialog, then try changing your view type from icons to Column mode.