Herbs brewed into tea (not coffee) using the UL Barista station or the mod should provide the same benefits as eating them raw or in food, only more subtly and perhaps for not as long.
Herb nausea is caused by low to medium quality herbs such as one finds in a grocery store. Growing your own higher quality herbs if any of your sims have the gardening skill or being lucky enough to find them for sale on the Al Fresco produce carts if you have that set will not do this or not nearly as often, am pretty sure that Perfect quality herbs never will. There is also an LTR that combats herb nausea, I believe it's the one called Simmunity. And one can also eat Sweet Grass (or drink Sweet Grass tea) to get rid of the nausea as well as buzz crashes, but then one still doesn't have the benefit that the original herb was supposed to produce so a third helping of herbs is required to try again. Weight gain can happen if the sim becomes Stuffed while working through all of this. :)