Oddly enough there is a level of comfort in suicidal ideation
Yep, at least you know what your going to do and what the future holds. When your stuck in the limbo of not wanting to live or die and just going through the motions for whatever reason everything feels aimless. I can empathize with the OP because I want to be gone badly but I feel as though I need a final push to go through with things and it doesn't help that people are giving me slivers of hope for the future and even though I know from experience that such won't pan out I keep thinking deep down "maybe this time things will work" and no matter how hard I fight against what is likely false hope I am a curious being as I am human so I feel the desire to see where things lead.
It's like watching a series you are into and your half-way through the season and want to shelve it as you know it's likely going to just be filled to the brim with cliché but you just have to know how things will pan out so you continue watching it anyways despite the obvious disappointment you'll face by the end.
I blame all of this on the human condition and it's funny how the only cures for this are either succeeding in realizing your ambitions come to fruition or CTB but only the latter option offers a true ending to the story because as we all know that nobody can stay at the top forever and you'll eventually tumble back down, maybe not to the bottom but it takes a LOT of effort to get back to where you were which requires energy, dedication, and luck and it all just ends up becoming a convoluted mess where your left thinking "holy shit, what happened?" and then fast-forward a few decades and your in a nursing home eating through a straw and taking pill cocktails until you end up in the same place anyways.
Life isn't rocket science but you'd think it was considering how our brains are wired and detangling such is an impossible task to say the least but recognizing such is fully within our capabilities.