Effects from Eating Herbalism Plants

ChamomileGives +1-3 4 hour Happy Moodlet (Quality-determined)
Toxic ChamomileGives +2 Tense Moodlet for 2h
ElderberryGives +1-3 4 hour Happy Moodlet (Quality-determined)
Noxious ElderberryGives +2 Sad Moodlet for 2h
HuckleberryGives +1-3 4 hour Happy Moodlet (Quality-determined)
MuckleberryGives +2 Dazed Moodlet for 2h. Dazed Sims are better targets for Romance.
FireleafGives +1-3 4 hour Happy Moodlet (Quality-determined)
Poison FireleafGives +2 Angry Moodlet for 2h
Morel MushroomGives +1-3 4 hour Happy Moodlet (Quality-determined)
False Morel MushroomGives +2 Uncomfortable for 2h
Source: Carl’s Sims 4: The Herbalism Skill