Dropdown menu of node titles that are made by a view
I don't know if or how the Superfish module integrates with Menu Views. Off the top of my head I kind of suspect it doesn't...

The simplest solution is to use CSS to hide the view except during the parent's :hover state. You can pick up a simple js to make that function in IE7 and below. There are of course plenty of other, mostly javascript or jQuery-based, solutions.