Most of the interesting mods have already been integrated into the core KSP1 game. About the only ones worth mentioning are ScanSat (adds planetary observation sensors) and EngineerEverywhere (or something. It adds the thrust-weight-ratio display info without a part). The graphics are enhancements are just pretty pictures, that do nothing.
KSP2 has a lot of potential, and is very pretty, but unfortunately also requires a pretty beefy machine to run well - and even with a beefy machine, it can still stutter quite a bit. I honestly am not sure if I own KSP2 or not - my Steam library is like most people's, and I often treat game purchases a just a "you did a good thing, here's some money" - but I certainly can't run it on any hardware in my house.
I recommend CKAN for installing and maintaining mods for KSP 1.