Ok, so nothing extreme.
For general riding around town, "Hybrids" are popular. And, there is a related class of "flat bar road bikes".
As people begin to push distances, the "drop bar" racing style bikes become more popular, but it may take some time to get used to the riding position.
There are tons of used bikes on the market. The advantage is that you have less invested if this all doesn't pan out. But, many will require a tune-up to get on the road, so it depends a bit on your mechanical aptitude.
For new bikes, visit your favorite local bike shop, and they should help you find a comfortable bike that is the right size.
An additional class of bikes would be the drop bar endurance bikes. For example the Specialized Roubaix. They don't come cheap, but are supposed to give a more comfortable ride.