Like another post mentioned, dynamic mics like the Shure SM58 mentioned here, can drive a cable directly or through a small built-in transformer. They're still used in live sound, though condensers have become quite common there too. Condensers still tend to have somewhat better behavior, such as signal-to-noise, than electrets.
Of course everything has to be amplified or fed to a digitizer at some point. The issue is where the preamp needs to be physically located.
These can be run in reverse as well, it requires CB custom electronics so it’s not something a lay person can do out of the box.
But you probsbly think about smaller form mics like found on headsets (Electrets).