Good luck, I am where you are now a few years back. Here is what I have learned in a few years trying to enjoy Astronomy AND photography:
1) there is a reason there are so many types of telescopes, none do it all and whatever it is you want to do at the moment will be something you need a new scope for!
2) If you are serious about visual OR (and especially) photography you will be unhappy buying a budget scope and wanting to throw it away in less than a year.
3) Pick one type of photography and run with it for a LONG time. Consensus is (and I agree) a high quality, low magnification reflector (used price $300-$500) is the starting point for photography, but unfortunately is exactly opposite of what a new person to the hobby wants for visual (we all want a big scope to count the rocks in the rings of Saturn).
4)If you stick with the hobby you WILL buy multiple scopes for multiple purposes, accept it, deal with it and buy the best you can afford or you will wind up having to buy it again later.
5) For photography, the mount is more important than the scope. I know it hurts to pay big bucks for a lump of metal that holds your beautifully crafted scope, but the sooner you accept this the more money you will save.
6) Seriously consider buying used. Most us astronomers are pretty anal about our gear and keep it in good shape and we love buying new gear (even when we don't need to) so always selling high quality used gear 35-50% off new prices. A quality used $500 scope will crush any $500 new scope you can ever purchase.
7) You will be confused and discouraged trying to get photos like you see online for a LONG time. It is a VERY challenging thing to take photos of anything other than the moon.
8) Spend more on the mount than the scope (yes I know I already said this, but saying it again!)
9) Be ready to buy 500 "widgets" that you never thought you needed...that you need (cameras, cables, guide scopes, filters, software, spacers, connectors, the list never ends)
10) Don't get discouraged, keep at it, its a time sink and a money pit to do it right, but it does get easier, just don't tell the wife how many scopes you really have and hope she never asks.
11) Find a club or someone already involved and learn from them (I failed at this part greatly and regret it to this day!).
12) Have fun and enjoy and share your results with us!