I think everyone is getting too wound up over frame materials. To the OP, just go ride a bunch of bikes in your size that are designed for what you hope to do (long rides, race, gravel, whatever). Pick the one that feels best to YOU. There is no ultimate "best" material or bike, just what works for you or doesn't.
I went out bike shopping a couple of months ago, pretty sure I was going to end up on steel, but ended up on a Specialized Diverge Comp (carbon). Rode it and absolutely fell in love with it. Went away for a week, rode other things, then came back and took the Diverge out again for a longer ride. Tried to talk myself out of it (because of the price) but really loved the bike (and it was on sale), so I bought it. You should do something similar: buy a bike that you just love to ride and not worry about who thinks what material is best.