It's very difficult to sleep under the influence of a moderate psilocybin dose. Or any other of the classic psychedelics for that matter, like LSD or mescaline.

I'm not sure what the mechanism is but they definitely have a stimulant-like feel sometimes (especially LSD).

So you have it right, just need to take it in the morning before going to work

I don’t really remember my dreams anymore, but if I go to bed having consumed weed (or one time, a light dose of mushrooms) I end up having a psychedelic version of fever dreams - extremely intense visualisations of thought structures that just keep folding out of themselves, that appear otherwise unfathomly huge and intricate. It’s quite uncomfortable wanting to sleep and rest from your thoughts but the substance won’t let you.

I grew some mushrooms at home for the first time. Ate one at 8pm at a concert tonight. Its now 3am and despite taking melatonin, I cannot get to sleep.

That’s normal. Best to just relax maybe have some food/drink and eventually you’ll sleep but it’s not a party drug if you’re gonna work the next day or something

Melatonin is effective ~5 hours later. No need to take more than 0.3 mg.

What you should try is L-Theanine just before going to sleep, it's effective against Caffeine, not sure about Psilocybin.