Don't give up on a road bike.... if that is what you want get the one you want and change the stem (hold the bars) to one that gives you a more upright position.
I went from the stock 110 degree stem to a 140 degree stem while the 125 degree stem that is perfect for me was on order.
And yes I would look at an Anyroad or other gravel/Cyclocross bikes too.
I currently am back to a 110 degree stem, but the geometry of this frame puts it very close to what I was on the other frame with a 125 degree stem.
Cycling shouldn't be uncomfortable.
No matter what bike you buy get a proper bike fit as it will allow you to ride further more comfortably, and if you are more comfortable you are more likely to ride more frequently.
I am currently 360 pounds riding a carbon fiber road bike (Orbea Orca) in 60cm.