
Shure
SM58
Indestructible live workhorse; but muffled for studio vocals.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
Oh, my. I HATE Rode's wireless mics! Who thinks having a giant brick hanging off their t-shirt looks professional!? The gimbal at least makes sense. The rest is overkill, but works.
Canon XA11, Canon 500D, Gopro Hero 8 and 10, Android phone, Rode wireless mics for the Canon XA11 and one I'll use on one of the Gopros every once in a while. Either way too much for what I'm doing these days lol.
Honestly a lot of it is just the nature of video vs audio-only content - people are way more forgiving of mediocre audio when they're watching someone's face vs listening to a pure podcast where audio quality is literally everything Also those Rode wireless mics are actually pretty decent and have built-in noise reduction, plus most YouTubers are doing at least some basic audio cleanup in post even if they don't mention it. Your setup is definitely overkill for casual YouTube content but perfect for professional podcasting where audio quality can make or break you
Used Rode rx/tx but this was only one channel. I then moved to DJI2 - love the functionality and the sound was clean. However, plugging a lav into the transmitter did not work well. There was frequently a pop like the jack was loosing connection. Hooking the cable under the clip and even putting in a broadcast loop did not solve the problem. Nothing did. I have now moved to the DJI mini. The magnet is small and you can turn the TX inside the shirt if you really want to hide it. Sound is not as dynamic as the DJI2 but I adjust it in post. I do ENG for broadcast and the small size and portability works great for me.
I see you got rid of your bias against wireless. Get a Rode wireless kit. Records to camera and the transmitter at the same time.
I personally think it can take a bit of tuning for your voice as well.. any time I used a blue yeti (I had a pro for years back in 2015-2016) and it didn't take to my tone well and would cause peaking and such with any setting, I ended up with a ShureSM58S but make sure not to get a fake one. Go to a legit seller as there are many out there selling copycats. I run it via XLR into a Fifine SC3 Mixer I have a 2 pc setup and also run a Hollyland Wireless mic or Rode Wireless mic kit when I am doing hand reveal streams. I also run my mics through a splitter and combiner. There are a lot of things you can do with audio once you get there but Generally Check your space, check local audio places to see if you can test a mic or even rent one, then invest in the one you find works best for you. Good luck!

Shure
SM58
Indestructible live workhorse; but muffled for studio vocals.

Shure
SM57-LC
Versatile for instruments; needs pop filter for vocals.

DJI
Mic 2
Unbeatable convenience, 32-bit float; but poor Bluetooth audio.

Samson Technologies
Q2U USB/XLR Dynamic Microphone with Accessories
Great value dual USB/XLR; recent price increase noted.

Shure
SM7B Vocal Dynamic Microphone
Professional vocal sound; but expensive, needs external amplifier.