My wife and I both have lives now because of it. In my case, I have body aches from a bad car wreck, and after ten years of only getting maybe 3 hours of good sleep each night, followed by prescribed meds that left me dopey all day long, marijuana was legalized here. My wife makes CBD cookies for me and after a bit of experimenting to get the right amount, I now generally wake up feeling refreshed and have even been needing less sleep for the last several years.
On the other hand, my wife lives with chronic pain from childhood accidents including one where she was partially paralyzed for a few years (spine injuries suck!). She is now on permanent disability because she wasn't able to sit at a desk for 8 hours a day. Since mj was legalized, she got off the opioids, smokes throughout the day to manage the pain as needed, but is able to get things done around the house when she's having good days (which is most of the time).
If you want to go down this road, you will definitely get a better experience than you have with doctor-prescribed medications, however because there's still not a lot of data on the subject you will want to find what works for YOU. If you do any cooking, learn how to make oil and butter from mj, and use that to bake your own cookies, cakes, or whatever. This way you have control over what strains go in to what you are eating, and you can control how much of it is used. You can get instruments to be more scientific with it, but really once you have some experience with CBD/mj it won't really matter. It also tends to be quite a lot cheaper than buying pre-made edibles from the store.
Now, for what to expect... For my use, the right amount is something that I barely feel, if at all. What I do notice is once it starts to kick in (which is right before bed anyway), I start to drift off and have to make an effort to get up and go to bed. If I eat too much then yeah, things can start to get a bit crazy, and I don't get as good of sleep that night. For my wife managing her pain, she describes it by saying the pain doesn't really go away, she just stops caring about it so it doesn't control her life. Again, the right amount isn't so much that she acts like a stoner all the time (and she consumes a LOT more than I do), but rather it's enough that she can start to function again despite the pain. So it's not unusual for you to not feel anything, but it's also possible you're simply not getting enough.
Hope that helps?