Basic advice as I’ve some a bit of this lately. For shooting small PN and most galaxies you need focal length. Independent of aperture it’s practical and possible to image all the way up to F/12. You’ll have to fight a bit more for the needed integration time and pick your targets wisely but It’s not imposable to image at those ratios. The type of scope is less important than the quality of the optics. It has to be sharp because you’re going to be pushing it. Don’t be afraid to oversample and despite general advice, you can use a Barlow, just make sure it’s high quality and well color corrected.
The really big factor in how far you can push this is your local seeing. I’m in the central United States where the seeing is highly variable. When I’m imaging at 0.66” per pixel, I can still get useful data on rough nights, not so at 0.33”. At least not with a huge amount of culling which is the last thing you want to have to do with a slow system.
On the processing side, good sharping tools become really important. BlurX is the gold standard right now as it tightens up the images while preserving star profiles. Cosmic Clarity by Seti Astro is powerful but you’ll have to work hard to preserve your stars. The sharpening tools in Affinity are also excellent and can be layered in to get that final finish. This is an area were it pays to experiment with frequency separation, wavelets and so on. All of these tools are powerful and can ruin an image quicker than boiled asparagus so you’ll need a light hand and good judgement.