A lot can be done during the fitting process to put you in a more upright position if that is what you want: the easiest is just selecting a stem with a higher rise and shorter reach.

I have owned a lot of different bikes: flat bar fitness bikes, cyclocross, road and mountain. The fitness bike was basically good at nothing. The cyclocross bike was a bike upgrade. I could put on road tires and keep up in faster group rides or I could take it off road. It was only when I tried keeping up on more dedicated mountain bike trails where it started lacking. It was then I decided to buy both road and mountain bikes. But if I had to pick just one bike to do everything, I would pick either a cyclocross/gravel bike or a hard tail mountain bike. To pick between them, ask yourself, are you going to be riding over rocks bigger than a baseball or riding over fallen small trees or large roots? If so get the mountain bike. Otherwise that specialized Dolce ego looks nice. If you go the mtb route, you can buy slick tires for the smooth roads.