Hi Astro_Nic,
I can only speak from my own experiences but it should hopefully be useful nonetheless. My first serious scope was an 8 inch newtonian on an eq mount (fully manual) back when I was in my late teens. At that time I was living in the centre of Derby and it was before things like the stellarium app etc. were available.
Maybe it was my age at the time but I found the whole deep sky thing pretty difficult under the light polluted skies and after a few years the scope was seldom used and then sold. Now, 15 or so years later I find myself under bortle 4/5 skies and I've now owned a 10" dob (goto) for just over a year and I tell you what, I wish I'd purchased a dobsonian all those years ago (even a non- goto) as it's the cheapest way to get a large aperture and it's just so simple to use. If you are only interested in visual observing and if deep sky is your primary interest, then I think it's the way to go (and by the way, it still gives me stunning views of the moon and planets when conditions allow).
What I like about it is that as mine is a truss tube, it's easy to move in and out of the garage and take out in the car if I want to go somewhere darker( that's why I chose the 10 inch over the 12 in the end- I would have loved the 12 but I did have to consider moving it about). You literally plonk it down on the ground and away you go- perfect for those short breaks in the clouds! ( ok there's collimation to consider and star alignment with the goto but that's nothing too bad once you get the hang of it). I don't think goto is essential- it's a nice to have but star hopping is certainly more rewarding, I think if anything it's the tracking aspect I like the most.
But goto or not, owning a dob has really opened up the hobby for me and ultimately, a telescope that is easier to use is the one you will use more often, that much I do know.
Clear skies,
Rob.