So for someone like me who has never has a star gazing scope or know little about them, what is a good introduction beginners product & price point in the purchase of one that makes the object clearer to see ?
These guys are thoroughly decent people and give good advice:
Best Starter Astronomy Telescope Guide for Beginners | First Light Optics
I absolutely wouldn't ever buy from anyone other than a specialist astronomy supplier. There's a lot of tat about at the cheaper end of the market.
What's the best choice is a complex question to answer though, because the preferred type of telescope for viewing solar system objects is likely to be different from that for viewing objects like nebulae and star clusters in the rest of the galaxy and for other galaxies and neither may be the best choice for astrophotography (which is pretty much unavoidably expensive to get into -- it makes beekeeping look very cheap). Storage space can be an issue too, though perhaps less so for people who already keep bees
It takes time to train yourself to see fainter targets or to interpret detail in the brighter ones. Making stuff appear "bigger" doesn't always mean you can see more. It's a patient person's hobby
If you were thinking of buying, perhaps a good way forward would be to find a local astronomy group and see if you can go along to a few meetings and/or observing sessions so you get a good idea of what options there are.
James