Justin: it was "Return of the Phantom" and yes, the best part of the game was the opening sequence.
SPOILER BELOW (for anyone who might actually go hunt down this game...as I did)
Basic plot: It's 1993 (or 4, but does it really matter?) and you are a detective named Raoul, attending a performance of a recently discovered manuscript for an opera called "Don Juan Triumphant" (supposedly written by "Erik: the Phantom of the Opera!"). The chandelier comes crashing down during the performance, leading many people to believe that the Phantom has returned, and is angry that his work is being produced. Your investigations lead you to the catwalks above the stage, where a mysterious masked figure appears out of nowhere to shove you over the railing...
...sending you back in time to the old days of the Paris Opera. You are now Raoul de Chagny...blah blah blah...like a condensed version of the book...and at the end you chase the Phantom to the chandelier where, upon removing his mask, he sends both of you plummeting towards your demise as he cuts the chandelier loose...
...and you wake up in 1993/4, the recent chandelier crash having never happened because, as you discover in a book in the library written by Mme. Giry, Erik and Raoul de Chagny both died in a tragic accident many years ago involving a chandelier crash. But whose shadow is that you see sneaking past the library as you read the book...?
And there you have it.
-- SDG