I just discovered this by accident and haven't seen it mentioned anywhere before:
With a finder window in column view, select an application so that the info and large icon for the app shows up in the right most column. You can then drag and drop documents onto the application's large icon in the info column to open them in that app.
Maybe this hint has gone unreported because it's hard to imagine it being very useful!
Mac OS X Hints
http://hints.macworld.com/article.php?story=20020125093642119