For me, weed have me the traditional euphoria, but also incredibly clarity of vision. I suddenly could see why I was unhappy with my life & what I needed to do to change it. Also, music appreciation like you mentioned. As if normally I hear music sort of compressed in mono & suddenly it was hi-fi & I could not only hear the separate instruments, but could hear the individual vibrations making up the notes. And, I also found it somewhat anti-addictive as I would do it once & then not want to for several months. I feel as if my life would be much better if I was able to partake of it once every few months. 

I haven't tried psilocybin. I went so far as getting spores & growing some, but was too afraid to try (aside from micro-dosing where I never noticed anything.) I have a lot of anxiety about having a bad trip & going in feeling like that seems like a good way to guarantee a bad trip. I also don't have anyone IRL I can trust enough to sit with me & am afraid to try it alone.