Overboard! is something that always comes into my mind when talking about demos. (Apparently "Shipwreckers!" in NA.) Not sure if that's my favourite, but it's something that has stayed with me over 20 years, "that ship game demo on PS1".
The demo disc itself is of course this classic.