+1 to the OP for admitting that you find exploration dull and depressing but not going on to insult those who don't. It's a rarity on the forums these days. Most rants come in the form "x sucks, and if you like x then you're stupid," so kudos for avoiding that.
As I've said elsewhere, for folk who don't get something out of collecting screenshots of nice looking places they'll probably never visit again, exploration really doesn't serve much purpose other than to fill up the blue progress bar and give you a few First Discovered tags. And of course you've hit upon exploration's core problem (pun not intended); the further you go the further you have to get back before you can do anything other than more exploration or CQC. If the bug doesn't bite hard, that realisation will force you to turn back that much quicker.
Exploration really comes into its own with a second account, so you can enjoy the occasional hours of solitude and astrophotography while also maintaining a presence in civilisation. But as buying a second account essentially rewards FD with money for not building multiple commander slots into the game itself, I fully understand why some people -- even those who enjoy exploration -- don't really see it as a viable option.
Said it better than I could ever do.
As above for me it's the putting my mark forever on the game as well as visiting places few dare to travel. There's some awe inspiring sights but as the OP correctly states they are few and far between.
Would recommend OP gets his fill of bubble combat/trade etc and then does a short 1 weekend trip to Barnards loop. Messier 78 Nebula, Vy Canis Majoris, Betelgeuse. Do the whole near the bubble exploration in a weekend, land on some planets, visit Mintaka for the black hole and see what you think after that. Cannot fault OP's reasoning or arguments, as above kudos for giving it a good go but since we don't know where Dantheman went we can't say if it was just a random patch of space or something more interesting