I'm the one building the system (although I am more a middle to back end developer rather than front end stuff plus this is replacing a number of disparate reporting tools that span the likes of SSRS 2005, Excel Spread sheets, Access Databases and god knows what else I don't about ) but wanted to know what the current trends were with menus in the modern web world. I have migrated from webforms over to MVC over the past 18 months and most of the products I have had to build during this time have had simple flat menus but as this is a more complex and longer term product I am trying to head off issues now before having to rewrite entire sections again because they have become overbearing or clunky to use plus it gives me a chance to try things out before an official launch for the product.
This is kind of an extension of my other thread where I have been building a dynamic reporting system which will satisfy most users but there are areas that are going to need to be crafted by me so that we can represent a lot of BI data in nice simple forms but as we have more and more data sources being brought in over the next 12 months or so I don't want the top menu bar to start bloating and taking up multiple lines as it will spoil the overall cleanness of the site I have built (admittedly it is using the default bootstrap theme for the majority of it)
I agree that an over-animated menu doesn't add anything and does become frustrating over time (although cool and funky to start off with) but I think a simple slide in menu from the left to display a vertical menu will allow me to have a nice clean top menu while hiding a lot of the options on the hidden/ off screen options. Therefore the user can decide if they want all the menu options on the screen or not to free up screen real estate.
Although it seems like I am probably looking for an issue that isn't there yet I know what my users are like and so I can just envisage what requests I will be asked to have this and that feature added which will require some link somewhere to get access to it (if not from the top menu then from somewhere within in the system)