I just released an update to Cargo Ships that makes Boats immune to the tile friction modifier. Cars and players will still be slowed down, but boats will travel just as fast as in vanilla.
A nice touch would be for Noxy to disable the water animations when the player is in a train or "indep-boat"-type car entity. Cargo Ships already produces its own wake effects.