You are correct that the different implementations are not compatible. There are no radios I know of that support more than one digital audio mode. Most desirable is a matter of opinion.
C4fm from yaesu is easiest from what I was told, never used it. DMR is the only one supported by more than one manufacturer. DMR is the only one I've used. DMR is roughly 5x as complex as an analog FM radio to configure.
My first radio was a DMR radio. I own 3 of them. I use my yaesu vx-6r and quansheng uv-k6 analog FM only radios the most. The quansheng is a great first radio if you aren't certain you will stick with the hobby, dirt cheap. If you are looking at analog radios, I would stick to radios supported by chirp.
If you are set on a digital voice radio, go on repeaterbook and look at your local repeaters. An HT is only going to reach repeaters 10-15 miles away at most depending on terain without an external antenna of some kind. The best digital mode for you is the one with the repeater you can reach. Without that you need a hotspot or you overpaid for a feature you never use.