It depends.
I have a Cannondale F400 aluminum frame mountain bike. I love that bike and wouldn’t trade it for a CF mountain bike.
I have two Colnago CF bikes. I love those bikes. I wouldn’t trade them for an aluminum road bike.
Different conditions different materials.