"not all roads are great" is very subjective.
i dont know your budget
i dont know your size
did you ever have a bike before? how much experience do you have?
are you handy? are you afraid to wrench on it?
completely blind advice would be to get an old name brand mountain bike with no suspension if you aren't afraid to work on it from day one and maybe replace a few parts.
for example this: https://tucson.craigslist.org/bik/d/trek-7000/6190536775.html
i would clean and tune the drivetrain, inspect the brakes, maybe change the pads, and get semi slick tires.
if you have some extra cash maybe a low end mountain or hybrid from a big name brand.
I think road bikes are less forgiving to novices, both in comfort and handling.
get it from a local bike store as it would be assembled by hopefully someone experienced. the shops also often have free service for a year or so on new bikes.
you can also try out all different bikes there and they will help you out with sizing and fit.