@obsolesce the best telescope is the one that you will use. The biggest urge you need to fight is buying a larger scope as your first. What you want to do is get one that is a small light and you can setup fast.
One that is good for seeing and good pictures are kinda opposite ends of the spectrum. I do astrophotography as a hobby. (https://instagram.com/westtexasastro) I started off doing visual, the scope I started with is an Orion StarSeeker IV 127mm. It came with a motorized mount that points the telescope, once you set it up a couple times you can do it and align it in 5ish minutes. It is good for looking at the moon and planets, but you can see some of the brighter nebulas like The Orion Nebula. I’ve also hooked my DSLR to the back of it with a T adapter, but you could also get a mount to hold your smart phone over the eye piece to take pictures with as well.