raymo's images are pretty inspiring to a beginner imager like me. I don't expect I'll ever take large numbers of subs of a single object to get results like the pros but never say never
Visually, I feel 8" is a sweet spot...enough aperture for globs and brighter nebs to be interesting, but relatively compact and portable. Larger aperture is often better in this game, but it comes at a price, literally and physically the scopes get larger and heavier quickly (and/or much pricier!), so be sure to go see one before you buy.
One thing to understand is that a good visual scope is not necessarily a good imaging scope, and vice versa. Visually alone, it is tricky enough to find the right balance and many of us have more than one scope