From my experience if you take a really huge dose of LSD or mushrooms you will still feel different / changed for a few weeks to months to come. But if you just take a normal dose, it will pretty much be over the next day. I also believe that this is the more true the younger you are. If you get older then everything has already been settled in the brain, it had much more training to distinguish what is real and what is not and it will snap back to that much more easily and readily.
By "changed" I mean that you are for example more open to emotions, enthralled by nature, esotheric, mystic or artistic things and that you may derive some profound personal meaning from it. This can affect what you value in life, or how you view things, it might be a little bit like wearing rose-colored glasses. But it is not like the actual effects of the drug like hallucinations and such would stick with you.
Eventually though it will all wash out and the magic will just disappear.