I made some splashes using baked fluid simulation in Blender coupled with real-time VFX graph particles in Unity. This is a real 3D volumetric splash as compared to flat 2D splashes you get in most other games.
The sounds add to the satisfaction. There are about 30 different splash sounds depending on the water depth and player velocity. The splash sounds different underwater too.
Water slows you down a lot depending on depth. While you can run through shallow water, trying to do so in deep water is near impossible. It's much faster to swim instead.