I agree 100% with those who say the perfect all-round scope hasn't been invented yet.
If it were me, I'd buy the best dob I could afford for everyone in your family to get good views. Check out the Celestron Starsense dobs, which have a system whereby you can use a smartphone to link to the scope and point to the target you want to view. If you don't fancy that, StellaLyra do a wonderful range of dobs with the best accessories.
If you think a dob is too unwieldy, there are a lot of refractor choices but you'd have to get someone else to recommend which one and, importantly, which mount.
Whatever you decide, make sure you set aside some money to upgrade the cheap and often nasty eyepieces which the manufacturers supply.
Either way, I wouldn't leap into astrophotography until you have a bit more experience of the sky, not to mention deeper pockets!