Yeah, the saucer crash was spectacular on the big screen. Possibly ILM's finest non CGI sequence of the 1990's.
It really underscores the lack of emergency restraints on a starship though. And that broken window bubble over the bridge, what the heck? Did Sisko's baseball have a cameo that was cut?