My dad is on CBD oil for his arthritis and I give it to my old dog for his. It really does work.
I live in a state where pot is legal. I don't partake. My girlfriend has a vape thing with CBD oil that is THC free. She uses it to help her sleep on occasion. I've tried it and it does work.
My employer has a strict drug policy with random drug testing, so although I agree with the apparent benefits of it medicinally, I know that if I used it, then when I fill out the federal form and check the box "no" asking if I am a user of illegal substances, then I would be lying.
It really is a question of federal law vs. state law and the great legal minds on here can pontificate on it endlessly and with great effect.