Okay - a little background to the question in the title -
I currently live in Chicago so my dark sky/viewing is SERIOUSLY bad! Most places I could go with a telescope I literally can't even see enough stars to be able to sky hop. I bought a Zhumell a few years ago, but then I sold my car right afterwards. I get around everywhere by bike and was planning to build a trailer that I could use to haul the Z8 out of the city - maybe do some camping and be somewhere with slightly darker skies. I also have an e-bike with a LOT of range, mileage-wise so hauling a 'scope by bike is no big deal. However, I was concerned about collimation issues and safely cushioning the OTA for transport. Some folks on here a few years ago had suggested stripping all the parts off the Dob and making into one of those ultra-portable Dobs. That's more complexity than I want to deal with and there are some other issues as well.
I want to do a mix of visual observation but also maybe dabble a little bit in astrophotography. That pretty much rules out the Dob without undertaking some serious modifications, building a tracking base, etc. I'm not always going to live in Chicago, and my wife and I have been planning to move to the southwestern US for a few years now - probably Fort Collins, CO area or maybe Santa Fe/Albuquerque, NM area. So, better skies in the future and a house with a yard vs. crappy Chicago skies and apartment living. The plan is still to live car-free wherever we move so portability is again an issue. Given wanting to do some astrophotography, but even more, my current inability to really see a whole lot effectively where I live kind of gives the edge to the Celestron mentioned in the title. The automatic functions would allow me to view *some* variety of objects without trying to star hop in excessively light-polluted skies. Also, I can build a case for the Nexstar to transport it easier than I can transport a full-size Dob.
Basically, the time-sensitive part of this query is that Celestron is offering the Nexstar 8SE at $200 off, but just through today. I know they do these sales quite frequently though. Around $1000 is the limit of my budget. I'm seriously considering just buying the Nexstar and then trying to sell my Z8. The Z8 is in pristine, practically brand-new condition and I think I might even still have the box and all the foam packing materials in a closet. If I could sell that for close to new price shelling out for the Celestron might not sting so bad. Just thinking about the kind of observing I'd want to do and the fact that astronomy is not a major hobby for me, I'm leaning towards the Celestron over keeping the Z8 because I feel like I might get more use out of a guided scope rather than the cumbersome Dob. Anyone got any opinions or suggestions?