Jet propulsion isn't very efficient at all.
Not in aircraft and not in the water.
The most efficient jet engines are actually turbofans. The jet turbine makes thrust in the center but the shaft turns a big blower fan that moves high volume, lower pressure air around it.
And actual jet engine isn't that big around, it's the fan part that makes them so big.
Propeller aircraft are the most efficient, looked at as energy to thrust ratio.
For some reason you lose efficiency when you have super high velocity fluid moving past static fluid right out the rear of the thruster. That's what the turbofans solve, by surrounding the high velocity jet blast with slower moving air.
But I'm assuming that even with water, the same principles are at work.
Only because if water jets were even close to as practical as a propeller, they'd be more common on jon boats. A jon boat is flat bottomed specifically for shallow water.
A water jet is ideal for shallow water propulsion though. Look at a jet ski on a trailer. The water nozzle is no lower than the bottom of the hull. It's not sticking down below, exposed to damage from rocks and beaching.
Another thing about props that make them suck in shallow water is what I incorrectly call cavitation.
The cavitation you referred to in your Detroit engine, I would have called "pitting" because the maritime use of the word is what I'm used to.
An introduction to propeller cavitation
An outboard motor can get cavitation at any depth but a trolling motor isn't powerful enough. That's why I'm technically wrong when I call it that.
But what happens to my trolling motor if I have it set for minimum depth is it pulls air down from the surface, makes little whirlpools & lots of awkward sounding noises you'd most likely associate with a public bathroom at a Taco Bell.
I don't know what that effect is called, but I think it's caused by the low pressure on the front side of the prop, combined with turbulence. I call it cavitation even though I know it's incorrect, just similar.
@Hammer166? What's the science word for that?
LMAO, he's going to start charging for the use of his encyclopedia.
Anyway, in order to run my trolling motor on top speed without it making those awful noises

I have to set it so the top of the prop is at least 6" or so below the surface.
So with an 8" prop (I think) and the skeg sticking even deeper, I need the water to be over a foot deep even though the raft has only ever needed 4" even when loaded up.
And thank God for skegs. I'd have destroyed SO many trolling motor props in the shallow, rocky Des Plaines River without one.
I even had a skeg break off of one & when I got home I made a new one out of steel, bolting it to the aluminum I can't weld to, out of desperation because I didn't have the money for a new trolling motor. Amazingly it never broke.
We should have a national holiday just for the appreciation of boat motor skegs.