I've been dry herb vaping CBD nightly for around 3 years and I've found that it depends a LOT on the strain. Some have had no effect at all, while other strains can knock me on my ass.
The stains that don't have much effect can still be good if the flavor it right because I'll mix it in with other stains. I've gotten pretty good at being able to dose appropriately with a nice balance between flavor and effect.
For times when I'm looking for a bit 'more' of a hit, I'll mix in some full strength THC bud too, but mostly I just stick with the CBD flower.
My current favorites are THERAPY from Fields of Hemp (though, it's rare any more that they have it in stock), and OLYMPUS MONS from Holy City Farms.