While there are issues reported with Photoshop and Lightroom CS 6 in Mojave, I've been running both successfully with no issues for ages now on my MacBook Pro. I do have a CC subscription on my iMac, and it runs the latest OS - and it is where I do most of my work, but I've left the laptop at Mojave for now. (both machines are new this year - it was an expensive year!)
Going forward, I'd have a good look at Affinity's Publisher as an InDesign replacement; it is what I am now using and quite like. I will likely continue with the CC photo subscription for now - though bought Capture One as a Lightroom replacement. I also have Affinity Photo, which does much of what Photoshop does. The problem as always, is finding the time to learn the new tools. I'm so used to the Lightroom/PS workflow...