I just recently purchased a 2019 Roubaix and I was a bit skeptical on how much the future shock would do but I'm a big fan now. I don't generally ride trails or gravel but I do ride on very rural roads that have not had a new layer of pavement in 40 years or more. Compared to my old 09 Roubaix and even compared with an old steel mountain bike with 1.75 tires at low pressure, the new bike excels in comfort.
As mentioned above, I think the larger tires help to smooth the roughness while the FS and rear shock absorbing features help with the cracks, ridges, and potholes, that are unavoidable on many of the roads I frequent.
If you ride generally good pavement, you can probably do fine with any quality endurance frame.