The most underrated and under-publicized impact of resistance training is the improvements to your mental health. And to be clear, we're not talking about secondary mental health improvements that come as a result of other primary impacts, (e.g. developing better mental health because of improved social experiences or positive feedback from others). No, we're talking about
primary
mental health improvements--lifting weights is excellent for your brain health in and of itself, and is linked with lower depression, increased self-esteem and self-efficacy, lower anxiety, increased focus and attention and other executive function-related domains, increased energy, etc. It also can help increase motivation, ironically, even though low motivation is one of the biggest barriers to resistance training, in the first place. I should add via edit here that these all apply irrespective of your height, though I of course acknowledge and validate that the impact of lifting on your social life and ways people perceive you could be modulated by any number of physical feature factors, most certainly including height.
If resistance training interests you, it's definitely a worthwhile endeavor. You don't need to make it about anything aesthetic. In fact, making it about aesthetics is sometimes what makes people stop lifting. There's nothing wrong with having aesthetic goals or desires, but IMO, as a licensed mental health professional
and
certified personal trainer, I find the mental health benefits are far more meaningful for most.
And this doesn't even get into the literal physical health benefits--increased bone health, protective factors for your bones/muscles/joints as you age, increased mobility and flexibility if training long length muscle positions under weighted stretch, etc.
You certainly don't need to resistance train. There's no moral or sociocultural imperative to do so. But if you want to, or if you think some of those benefits I described could be helpful to you and you want to test it out for yourself, I encourage you to give yourself permission to give it a try.