I am a fairly new rider
I bought a road bike in 2011 and while it was fun, it was harsh and i always wanted to go on the gravel trails but didnt because the little 23c tires
Then in 2016 i bought a gravel bike with 32or36c tires and it was fun for about a month but quickly got boring asf on the paved street sold it and kept on my 2011 road bike
I was still seeking a little more comfort and the ability to hit hard pack.... i ended up on a 2019 Roubaix its got future shock, carbon frame, carbon seatpost and 28c tires
I feel like i can go anywhere now, even off curbs and tear down sidewalks, its super smooth, i can go fast and have the option to go up to 30c tires
If that sounds like you consider a road bike you can stuff 30 or 32 tires in or go for a pure cyclocross/gravel bike to get a mix of everything
other option is always add to the bike stall and get 1 for each