Do you share a room with a partner? If not, you could always set up a corner away from the bed where you sit. It's about not doing anything in bed except sleeping (not lying there 'tired' but actually needing to fall asleep) or ionically having sex (that was allowed). But nothing else.
I do think it's worth trying. I don't think you need several weeks off to do it. I found it quite quick to get used to - my sleep was so bad it wasn't a big hit.
It was recommended by my GP at the time, who then left the practice and set up privately, as someone who is quite leading in the field of CBT type practice for insomnia (and works a lot with menopausal women, if that's your related issue).
I do think it's smart to avoid relying on drugs, especially medication, as it's a slippery slope; and also - supplements. Your body just gets used to them, so even after the initial relief, their support wears off. I wouldn't also take melatonin long term as it starts to deplete your natural production of it, which you don't want.
I really sympathise; it's a shitfest when you don't sleep well and it has awful effects. I hope you get to try a CBT type programme, it might be the answer. Good luck