I don't know enough about meditation to comment on the dark night (besides suspecting I'm there now), but what you're describing does sound very familiar to me. In my case, in exploring my brain I dealt with depression, then anxiety, then discovered I probably had ADHD-PI all along. For me, doing things was painful because my only motivational tool was (subconscious) emotional abuse. I bullied and scared myself into getting things done, so no wonder I felt like shit.

Unfortunately, without that hurtful motivation... I still haven't discovered how deep the adhd goes, or what I can use for sustainable motivation. Holy fuck am I ever slow at doing things - and it doesn't help that I've now got serious medical problems and serious side-effects from the medication I need. I have hope, though - I've still got medication options to try out, and there was some compassionate-mindfulness thing I've done a few times that seemed to boost the benefits of the adhd medication I'm on, and some other odds and ends to look into. The "honeymoon period" with my adhd medication was pretty amazing - like a ball of sunshine in my belly that let me Just Choose to do a thing or not do it, and life didn't need a point. I have a feeling meditation can get me there too, but I'm still on the internet editing this post instead of meditating, so I might need the help of a medication change too. good thing I've got an appointment to talk about that issue soon.
So... I strongly suggest talking with a doctor, therapist and/or psychiatrist about these things. CBT might be a thing worth googling too - your comment about not feeling like you have depression sounded like an Emotional Reasoning distortion (
https://en.wikipedia.org/wiki/Emotional_reasoning ). Even if you don't find any medical issue, you'll learn useful skills. I also think meditation is probably part of the solution, even if it doesn't "fix" you in the way you're hoping for.

Good luck!