I tried getting Andromeda with my Nikon D90 and got zilch. I really have respect for those that get amazing photos, it is a lot more that aiming and a long exposure time.
Well gee whiz. Andromeda is pretty easy, at least to get the shape, you know? I’ve got it somewhere! ... Ah yes, I remember it well!
A digital camera alone will record very good photos.
A telescope will help make the photos better by enlarging the objects.
Advice for First Time Telescope Buyers
http://www.rocketroberts.com/astro/first.htm
How Big?
http://uncle-rods.blogspot.com/2011/01/uncle-rods-telescope-academy-how-big.html
Can you see the Flag on the Moon with a Telescope?
http://www.rocketroberts.com/astro/flag_on_moon.htm
This guy takes great photos including the space station:
ASTROPHOTOGRAPHY - THIERRY LEGAULT
http://www.astrophoto.fr/
Another who takes great photos. He shows what he uses to take the photos.
Russell Croman Astrophotography
http://www.rc-astro.com/index.php
Using a Canon camera:
BudgetAstro
http://www.budgetastro.net/guest-images.html
Using a Nikon
Nikon D810a astrophotography sample images
No telescope? No problem! You can still shoot deep-sky astrophotography images like a pro.
https://photographingspace.com/deep-sky-astrophotography-without-telescope/
Wally’s pics
http://astropics.com/
Pretty soon you will want to get a big telescope.
https://en.wikipedia.org/wiki/List_of_largest_optical_reflecting_telescopes
The World’s Largest Telescope
The biggest is 128 foot or 1,536” diameter Extremely Large Telescope
https://www.forbes.com/sites/startswithabang/2017/09/13/a-new-record-nears-the-worlds-largest-telescope-prepares-for-completion/#65ae8172392c
You just need a shed to house your telescope
http://www.rocketroberts.com/astro/observatory.htm