I haven't tried this myself, but I've been told that filling all the holes in the bottom of your shoe with hot melt glue helps. Keeping the water out completely apparently requires the hot glue and then saran wrapping your entire shoe and carefully poking out the cleats, but as you said, you'd sweat inside like a sauna.
Any wet ride I do, I just expect to get wet, especially my feet.
__________________
It's like riding a bicycle