The character would make a pretty lousy Captain. Regular Captain anyway. Temporary in a crisis or something? Probably passable and good but Stamets hasn't shown himself to be particularly strong when it comes to that aspect of his role. He's very impacted by emotions and focuses on that and his science. Then again he never wanted to sign up with Starfleet in the first place. He got roped into it and has only been part of it for a handful of years, honestly not much more than Tilly. Starfleet roped him into the Klingon War with his research on the Mycelial Network. That only started a year before Episode 3 of DSC. Meaning that Stamets had been part of Starfleet for, at most, a year by the time we first see him. Explains a lot as to why he's so angry and bitter. Also why he changes so much on that front throughout the show.
Eh, sometimes I find it more fun to take it seriously and respond in that manner. Besides I get to talk about something I think is cool. Lemmy is pretty fuckin dope.
Also, yes! I did find this post from your notification. I likely would have come across it anyway because I check the community frequently, but you let me know it existed well before I checked the community on its own.