My 1st thought was to say: 'All this and much more!' -- but actually I am not sure if it is sedative and it doesnt work as afrodisiac (for me peculiar). My guess: coffee works as stimulator -- and being over-stimulated, being extra-stimulated, the nervous system makes a move in the opposite direction - i.e. sedation, drowsiness, etc. so .... you should not drink coffee instead of a sleeping pill :) although, of course, such an effect can also be obtained...

I think coffee is a stimulant, and therefore (of course) a general upper! it rewards us, and causes a conditioned reflex/addiction, so that the smell of ground coffee itself (of course, I'm talking about freshly ground coffee!) -- can raise the mood, and promises an imminent stimulating effect... one (mentally) is already starting to get everything that they know coffee promises them.

My humble thoughts are accompanied by a photo of the jezzwa that provides freshly brewed coffee to me and my wife. (Clickable!)