The gravel vs. road bike question is common. You can ride a gravel bike on the road, but you can't ride a road bike on gravel, so many people just get a gravel bike and ride it both ways. That's the simplest approach and it works just fine. A road bike is faster and more efficient, but you might not care. But a gravel bike should not be more comfortable than a road bike. If a road bike isn't comfortable to ride for hours, then it's not fitted right, or you should use wider tires with lower pressures.
Contrary to the latest fads, wider tires are not actually faster or more efficient than skinny tires (all else equal, appropriate tires & surfaces). The point is not that wide tires are faster, but they aren't (much) slower. What everyone's so excited about is that the performance penalty of a wider tire is much smaller than has been commonly believed for the past several decades. In some cases, there is no penalty. So if you want to run 30mm (wide) tires on a road bike, at around 60-75 PSI pressures, go right ahead. It will have great comfort and traction and any loss of efficiency might not even be noticeable.
In short, don't get a gravel bike because it's more comfortable, because it isn't. The reason to get a gravel bike is flexibility: one bike to ride them all (gravel or pavement).
All that said, I don't own a gravel bike. I ride my MTB for anything non paved, and my road bike for pavement. I put thousands of miles per year on each of them. But that's a whole 'nuther story.