Well, the main (and very obvious) advantage to the resource leveling is that you won't have over-allocated resources, which means that the productivity of these resources will increase.
The reason why everyone thinks that resource leveling is bad is because it's a known fact that when a project manager levels the resources in his project schedule, it means that he didn't do a good job creating the project schedule in the first place.