Coffee is a stimulant and stimulants can absolutely cause drowsiness in people, usually those of us with ADHD.
If I'm not tired I can drink a small espresso and the stimulation from the caffeine wakes my brain up enough to actually deliver the sleepy hormones (this is how my Dr described it to me, anyway)