CF is the best material for bike frames, as it is for fishing rods, tennis racquets, golf club shafts...

At least for us Kansans, like Unagidon explained CF is really comfy. It doesn't beat you up on chip-and-seal, buckled asphalt (a major problem in areas that go from 0 F to 100 F) , and stuff like that as alu does.

If you're riding on silky smooth roads, the vibrations may not matter. Here CF is lghter than alu, but you can get lighter /better components for an alu bike at same price point, and achieve equal weights. CF cost is rapidly dropping. At some point, it may become as cheap as alu, for a better frame. Then alu will disappear from bikes.

If you find an alu bike and a CF bike that you kinda like, both, take them for 30-50 mi rides on roads you expect to ride, and see if you notice a difference or not. With an alu frame, you may be riding a CF fork. For example, Specialized went to CF/Zertz insert forks for their budget-conscious alu-framed bikes, and others also offer alu-frame/CF forks on their more-affordable bikes. They recognize that's where road vibes are most noticeably unpleasant. If that works for you, and the price is right, there you go.