Let's play.
Speed: Carbon fiber, then everything else
Comfort: Carbon fiber, then everything else. If you want comfort, buy a CF endurance bike designed to be comfortable, not a super stiff race bike.
Durability (provided you don't crash): CF, Steel & Titanium, Aluminium
Sustainability: Steel then aluminium / titanium and then CF, but it's largely overstated; the CO2 equivalent of a CF road bike is about 197 CO2 equivalent. That's the typical emissions you'd see driving for 1100km in a fairly economical car. If you drive a big truck, slash that in half.