A different perspective:
Like you I started with a hybrid and “upgraded” to a road bike (2016 Trek Domane 2.0 aluminum frame) to go faster and longer. After a couple of years riding that aluminum frame with skinny high pressure tires I started running into physical problems. Numbness, nerve pinches, neck issues, my body could not adapt! That vibration or road chatter was HORRIFIC and was literally shaking me apart. Had a C6-7 neck fusion to fix the worst of it.
Ive converted to gravel (or an all-road) bike with wider 40mm low pressure tubeless tires on a steel frame, carbon fork. Jamis Renegade. Life is MUCH better. Roads are much more comfortable over long distances. I even got into gravel riding, that’s another story.
So my advice is if you have to choose comfort over speed, choose comfort. I’m not racing or keeping pace with other roadies. My body isn’t getting any younger and vibration will kill you.