I wonder if this kind of menu possible in SharePoint 2010 OOTB (Without code). I want this menu showing in all sites and subsites in a site collection. I dont want pages, libraries or anything else showing up in the menu, but only the site hierarchy.If it is not possible OOTB, Otherwise i will try to develop some custom ascx control containing an aspmenu to place in masterpage.
You could have a look at this article. Customizing SharePoint 2010 global navigation with Css and jQuery or this one Customizing the SharePoint 2010 Menu with CSS and jQuery
Also, if you google jquery menu you will find lots of free nice looking menus you can customize.
Add the code to your masterpage and you should be good.