Against the rainy Paris night sky, Celine Dion staged the comeback of her career with a powerful performance from the Eiffel Tower to open the Olympic Games.