I've never made it enough of a habit to feel like I've had long-lasting changes, but I do have one friend with serious life-long depression, who has approached psilocybin use methodically, as a means of treatment along with periodic ketamine dosing, and it seems to be working quite well. However, I'm not sure about long-lasting effects after quitting these drugs entirely. There are so many life-factors influencing 'depression'.

Everything is just strange when tripping, from the things you see to human interactions to life in general- whether the strangeness is beautiful or terrifying depends on the trip, but afterward it can have a lasting (at least long after the drug has worn off) child-like appreciation for things that might've been mundane, boring, or tedious. How long this break from monotony, or revitalization lasts, is hard to say.