Hi Chris_1 and welcome to the forum and to re-cycling !
I came back to cycling about 15 yrs ago and wanted a bike to go on roads, local cycle paths, canal towpaths and a bit of light off-road, like on tracks through woods or forests.
My brother had a mountain bike and advised me to get one of the 'new' hybrids, which were just on the market. (maybe it was more than 15 yrs
) I took his advice and bought a Specialized CrossRoads Cruz - now superceded by the Spesh Sirrus.
It has been brilliant, done everything I wanted (including 50 miles round Lochs Rannoch and Tummel), comfortable, sufficiently rugged and reliable and I still use it for shopping and local rides.
Since then the range of bikes has increased hugely, with many niche bikes eg. a hybrid-that's-a-bit-more-rugged or a hybrid-type-that's-a-bit-quicker etc. etc. I would be the first to agree that it can be confusing.
just spend a bit if time at your LBS, if its quiet they'll show you whats what and you'll get a grasp of whats about.
... is some of the best advice you can get.
Depending on how fast you want to go
, there are cyclo-cross bikes too.
Either way, remember to factor in the addictive quality of cycling - and some extra dosh for clothes, spares, tools etc.
Enjoy it and let us know how you get on.