I was in the same situation some time ago. Personally I would maybe test a coupe, if you have the chance.
In relation to carbon vs other materials, a good carbon frame can be designed to be more comfortable than any other material, so don’t let that put you off. There is also some tuning you can do with the right seat post and seat without great expense.
I am personally a fan of cube bikes, I have tried against some larger more well known bike models and I have found them to be excellent value for money in terms of spec and weight. In rid quality and handling they are also a winner and in my opinion out handle my road bikes which have cost double.
Also in terms if sportive geometry, I thought about this before too. But in the end I went for a regular race geometry. I did this as I want to have the aggressive position if I want, you can just put an extra spacer to raise the handlebars if you are worried. Also, I don’t know what sportives you will be riding, but those I do have a great deal of climbing, 70% of the time or more is on the hoods.
I would take a good look at cube agree, don’t know much about the others, but in general good bikes. German quality and engineering, but you are not paying huge amounts for the name.
Good luck!