Well, the change has been active for a while now, giving us time to get used to it, and...
...I still hate it. The inconvenience that some people were experiencing in having to click twice on a tab link (assuming you were not active in that tab) under the previous system is nothing compared to the horrific navigation system that the mouseover tabs provide us with. If you are going to stick with this type of system (having tabbed menus), click tabs are the more user-friendly option. You can make jokes at my expense, call me retarded or slow or olde or what have you, but for quickly navigating the site, I have spent more time getting back from pages I didn't want to be on with the new system than I ever would have spent due to having to click on an inactive tab to get to the menus under it.