USB microphones are wonderfully convenient, by incorporating analog-to-digital converters right in the microphone allowing you to connect and record directly to a computer with just a USB cable. But with this simplicity comes a trade-off, the nature of those devices and some software typically allow for using only one mic at a time. If you want to use multiple microphones or have more control over the signal before it enters the computer (e.g. with a dedicated audio interface or a mixer with effects), an analog microphone is the way to go. XLR has been the ‘mic cable’ standard for quite a long time. Its 3-pin system allows mics to connect to mixers, preamps, audio interfaces, and more. Setting up a system with XLR mics will require you to have an audio interface to convert your analog audio signal into a digital one that a computer can understand. Some mixers have an audio interface built-in specifically for this purpose, and that can certainly simplify things a bit.
If you’re going to set up a computer for recording and have a ‘dedicated station’, I can think of no better choice than the Samson G-Track Pro. This condenser microphone can connect directly to your computer without an audio interface. You can plug a second sound source into the back of it, and it has three of pickup patterns* that make it a great choice for music, speech, voiceover, and more.
If you are working in an untreated room, or in an area with a lot of ambient noise, a dynamic microphone is your best choice. If you are going to use multiple microphones for a number of sound sources like instruments one day and a guest speaker the next, then have a look at the Q8x. This analog handheld dynamic microphone works great for picking up only what’s in front of it, and rejecting other noise/sounds in the room.
One more option is the Q9U (coming Q1 2021), a dynamic broadcast microphone that will give you that ‘talk show host’ sound. The Q9U is also a hybrid mic, it can connect directly to your computer via USB or to a mixer with a standard mic (XLR) cable.