The bigger the lens or mirror the more light it gathers and the bigger the image and sharpness. Example F5 is wide field and f/10 or longer is high power but you need that bigger lens or mirror. I would get a reflector for the better image and lower cost. Also get very good eyepieces. Think about having to haul the telescope around too.
Range of telescopes:
https://www.telescope.com/Telescopes/1.uts
These guys are lucky. Nice photos.
Backyard Stargazers: Giant Telescopes for Serious Hobbyists
https://www.wired.com/2007/09/gallery-telescopes-2/
I have a Canon EOS R6 full frame sensor mirrorless camera that is so sensitive it can see the colors of the nebulas like Orion in the viewfinder!
How to Photograph the Milky Way
https://www.nikonusa.com/en/learn-and-explore/a/tips-and-techniques/how-to-photograph-the-milky-way.html
Biggest amateur telescope - It is a spy satellite 70” mirror!
https://www.google.com/search?q=biggest+amateur+telescope&source=lnms&tbm=isch&sa=X&ved=2ahUKEwi2zafahMr1AhVoI0QIHWJYC9EQ_AUoAXoECAEQAw&biw=1331&bih=684&dpr=1.3
Samples of what you can see with various sized telescopes.
What Can You See With Different Telescopes
http://www.deepskywatch.com/Articles/what-can-i-see-through-telescope.html