The best workout is the one that keeps you coming back. I love weights, and I’d encourage you to try one way before you quit entirely. Lifting is tied to so many physiological and psychological benefits it’s stupid.
So, look up the Starting Strength program. R/fitness recommends it highly for beginners. You’ll be packing on functional, sexy, metabolism boosting muscle in no time. It’s easy to approach and if you follow it closely it will make you LESS prone to injury.
Bets of luck!