I've heard Blue Yeti's over Zoom, and via YouTube -- they're very good microphones. Given the limits of Zoom sound, IMHO it's pointless to use anything more expensive. Since you own one (I think), let's start there.
. . . I tried Blue Yeti and it did not work well for both talking and playing. I use a grand piano. [b](a) So either my talking was too soft while piano playing volume was fine, or the other way around. (b) I would not want to purchase XLR mics with an additional USB audio interface. (c) if the mic has a built-in stand, that would be a plus.
(a) Presumably, you had the mic close to your mouth for "voice too loud", and close to the piano for "piano too loud":
. . . Why don't you position it in between those two positions ?
The Yeti lets you use a standard floor-mounted "boom mic stand" -- get one, and position the mic so that voice and piano are balanced nicely. The Yeti has a "figure 8" pattern -- that might give you the best results.
(b) That's a fine goal, _if_ you can do what you want to do, and keep yourself in "USB land". There are USB mics that have built-in compressors, but you might be better off using a software compressor _running on the computer_, between the USB mic input port, and the Zoom input.
The Blue Mic website talks about "Blue Voice", a computer-based "vocal chain", which includes a compressor. I don't know if it's free, but it could save you a lot of grief if it's tailored to Blue mic's.
Adding a second mic and compressor would be easy, if you were using XLR analog mic's and a mixer with built-in compressor and USB adapter. But you don't want to do that (and if you own the Yeti already, it will be costly to switch).
(c) Don't futz around with "built-in" mic stands. Get a floor-mounted boom stand, they're cheap enough.
This problem has been solved before, in several ways. There are several YouTube videos on setting up for Zoom lessons by Hugh Sung, put up by Cunningham Pianos. Worth watching.
PS -- Forgive me if I've suggested things that you've already ruled out, in previous posts.