I'm working on LaGuardia's Terminal B replacement. There are 5 or 6 separate models, running up to 60 Mb each. It takes up to 20 minutes to load a model on a purpose-designed work station.
It only works if someone has overall responsibility, like the architect. Even then there can be issues. The Terminal B model was supposed to be frozen for foundation, structural and most architectural half a year ago. Yeah, right. This can lead to huge amounts of redesign effort. What happens is the architect doesn't just move a wall, which is bad enough. He obliterates it and draws another wall. Now in BIM each family (think AutoCAD "block") is hosted, meaning it has to attach to something like a wall, floor, or ceiling. When the architect dematerializes the wall, all your receptacles, switches, etc, become orphans and they are floating in the middle of the model. Now you have to find all your orphans and reattach them to walls, ceiling, floors, etc. You can spend half your time or better in this exercise.
It's nothing like CAD. You'd be better off never having done CAD before you start BIM but that doesn't usually happen. All your habits and instincts for CAD not only don't apply in BIM, they can keep you from grasping the essentials. I'm sure I'll learn to love it, but probably not before I die.