Just like it's more (in)famous cousin, THC, cannabidiol (CBD) is a cannabinoid that is going to interact with people differently.
Some people, like me, really enjoy both THC and CBD. Other people don't enjoy either and don't get the same effect from them.
I've been using CBD for ~a year and haven't had any NSAID (Tylenol, Advil, Aspirin, etc.) since then (used to pop them on nearly a daily basis). I feel much healthier and I know my liver feels better about it. I definitely feel the effects of CBD in both my mood and my joint/muscle pain.
If it works for you, then you're definitely not throwing your money away. If it doesn't, then you definitely are. You won't know until you try.
I'd suggest getting a reputable brand (look for independent tests verifying their description of the dosage is correct) as well as a full spectrum oil/edible/gel cap. The full spectrum has other cannabinoids in trace amounts that help the "cascade" effect, which is a big part of cannabinoids working together for desired effects.