Its not Java 8 you need, thats really for the internet. What you need is the legacy java 6 runtime for High Sierra etc. this helps with starting up Adobe applications, download it from here, Download Java for OS X 2017-001
you may have to uninstall Java 8 first, refer to Javas instructions on how to do this. Once the legacy Java is installed you can then reinstall Java 8 if you want, I have both running on my Mac.
There is a website you can access to give you an idea of third party application compatibility, https://roaringapps.com/
click on 'view macOS apps' on the left side of the page and when the next screen loads type in the app you wish to know about, for example Adobe CS4, or Adobe CS6 and it will list which of the suites apps work with which macOS, the first page will show a list of 10 apps in the suite, but click the Display 10 apps button to reveal more per page.
Its not very good news about CS4 but CS6 is better and although it says Bridge won't work, on my mac it does. I primarily use Photoshop CS6 and the only tiny issue is in the Camera Raw dialogue the tooltips banners that pop up when mousing over stay instead of disappearing after a few seconds, making the screen quite cluttered. To stop this go to Photoshop, click on Preferences>Interface and uncheck Show Tool Tips.
Roaring Apps is not an absolute to app compatibility, it is only users like myself and you that provide the information for their website, but it is quite handy to give you an idea.
Hope things work out for you Merry Christmas and Happy Retirement.