Half-Life 2 always stands out in my mind for this due to it being such a physics playground.

I usually hate water areas in games, though 😂 Especially the Zelda ones.