I seem to remember one really horrible bit where you hovered over some swimming pools with robot sharks and stuff in them, then come through later with the water drained out. There were also sewer areas as well I think, Any water bits were always insta-death which was kinda frustrating.
Anyways it's one of the few computer games that could be considered a masterpiece, that's actually artistic. The art design still looks good now and the music will always be beautiful. There's supposed to be a remake coming with the possibility of an LBA 3 off that.