It's true it has more of the sneaking, exploration, and quests that people generally want, but if you're ready for endgame you'll be surprised by how much more time it'll take. It also makes things slower at a point where you're supposed to be finishing the Sabbat, an inevitable consequence of how it's put into a story at a time when the Sabbat are originally wiped out quickly. If I didn't mess up or make it bug on either playthrough, that makes Andrei a considerable loose end. I've haven't played CQM nearly as much as regular VTMB, but after I helped destroy two Sabbat factions I couldn't enter the hotel upon returning to Downtown and the quest was marked as completed.
During the non-Sabbat route, which is what I meant, I don't think you're given an opportunity to face Andrei for the last time.