I think the problem is that a lot of CBD products are isolate based - i.e. they isolate and extract ONLY the CBD and add that to products. This type of product has very limited benefits as cannabis (with or without THC) works because of a combination of cannabinoids, not just because of one isolated ingredient (such as CBD/THC).
If you intend to use CBD products, look for ones that claim to be "full spectrum", although these claims are often bullshit. There might be a small fraction of uses for isolate products, but currently they are sold as such due to the fact that CBD with zero (or close to zero) THC is legal to sell - but it is quite tricky to get the full spectrum extracted with no THC.
The most beneficial products contain all cannabinoids from a particular strain, and the benefits will vary based on which strain you use.
If getting "high" is a problem (for whatever reason), then you can always use a strain that has a higher CBD to THC ratio (such as ACDC, which is a 20:1 CBD:THC strain). This will give you the most "wellness" benefits, without any form of impairment.
As for wellness, cannabis is highly beneficial for various ailments, and again it will depend on the strain as to how effective it will be to treat whatever you need treated. As a rough reference, you can check out Leafly.com to find information on locally available strains and find ones that serve your intended purpose.
the "high" is probably one of the best stress relievers out there, and considering the state of the world, that alone makes it a worthwhile pursuit