well it really depends on the herb.. high cbd might work better for you because the trippy head high is somewhat reduced.
but yeah, I remember as a teen, when i used to smoke larger amounts than I do now, smoking immediately before bed meant that I would lie awake with trippy feelings and cevs for another hour or so until the head high died down and I got sleepy. I enjoyed it back then, but now, after some years of struggling with anxiety, it can get uncomfortable, so I don't smoke a lot before I go to bed anymore. small amounts an hour ahead of lying down definitely makes me tired though.