We have manual only inflatables as we use them both in the power boat and for kayaking. While kayaking a splash from a wave might trigger an auto inflatable.
Belt inflatables are another option for kayaking and SUPs.
https://www.youtube.com/watch?v=DB1K2wJC8Vc