Actually, tube mics are a subcategory of condenser mics.
Usually, the 3 categories of mics are: Dynamics, condensers, and ribbon mics (although ribbons are really a special subcategory of dynamics).
Dynamics use a diaphragm with a coil of wire attached and the coil is immersed in a magnetic field. When the diaphragm moves, the coil moves with it, and voltage is generated. In a ribbon mic, the coil and diaphragm is replaced by a simple piece of thin metal, suspended in a magnetic field.
A condenser mic is made up of a charged diaphragm and a back plate. When the diaphragm moves a voltage is produced. All condenser mics are VERY high impedance and that impedance needs to come down to a usable level, since high impedances don't travel very far very well. That's accomplished with either an internal FET (Field Effect Transistor), or a tube stage inside the mic.
Either way, you need power to operate the FET or the tube. Batteries work fine for FETs, but tube mics require an outboard power supply to supply the higher voltages needed to power a tube.
FET mics can be powered by 48 volt phantom power, or self contained batteries which can range from 1-1/2 volts to 70 volts, depending on the design requirements of the mic.
The sound of any particular mic depends on more factors (like polar pattern, diaphragm size, housing, etc.) than just whether it's a "dynamic, condenser, or tube mic".
There are very clean tube mics and there are tube mics that impart a lot of coloration to the sound (sometimes desirable, sometimes not). Same thing with condenser mics, ribbon mics, and dynamic mics.
Each mic type has its own strengths and weaknesses, but there's no way to make generalizations about the "sound" of each type of mic.
Trying to think that way will usually cause you more harm than good.