Hello!
I made a video with a temporary fix for interactive water, basically I attach that sim fluid to the character which solves the problem with different z in case you have several rivers or lakes with different z.
Personally, I have a problem with a large map that uses World Partition, for example the water interacts in the area where the character spawns but then if I load another cell and go back to the first cell the water is no longer interactive, I couldn’t get figure out what the cause is.