I'd like to get your thoughts on what my best option would be for a bike. Here is my background / need:

• My cycling experience is minimal. I rode a bicycle for 6+ years when I was in university + graduate school between my dorm and classes, almost on a daily basis, but that was a decade ago. Back then I rode a used Diamondback mountain bike I bought for $100 off Craigslist, with zero maintenance performed during those years
• As my name shows, I currently live in Hoboken -- some nice biking trail options around this town!
• Usage: The bike won't be for commuting, but rather weekend recreations. I'm hoping to spend 1-2 hours of riding every weekend, weather permitting. Also, it will be mostly on-road (little off-road options around here, unless I drive far outside the urban area)

And here are some questions that I have:

• Which bicycle type should I get? Based on what I read from stickies and other sources here, hybrid might be a safe bet. But since there will be very little (if at all) off-road, would it make sense to look for another type?
• Budget: I started out thinking I want to spend ~$300 or so (excluding accessories) but then, reading up on brand reviews here and also on details regarding part quality, it is sounding like stepping up to ~$500 range might be a sensible thing. Even with my light usage for my bike, am I still right to think this way?
• Through research, I found a few potential options that appeal to me. Do you have any thoughts on these options?
  • Raleigh 2018 Preston ($250)
  • Creme Cycles Caferacer Uno ($400)
  • Specialized Roll / other models at my local bike shop (ranges from $450-$700)
  • If there are other options you recommend, please let me know!

Thank you so much for your advice in advance!