Ok, I think I cannot list all drugs I have experience with, because it's so many, but I will try to think of the most important ones:
Magic mushrooms: 10/10. Not every trip was healing, some were just fun. But quite a few mushroom trips were very helpful to deal with my past. One of the most memorable experiences for me was a trip during which I could see a child version of myself and sided with her to fight against my abusive father. The good feeling this gave me stayed with me over the years (this trip I took more than 15 years ago).
LSD: 9/10. Although LSD trips are usually not as deep for me as mushrooms trips they were also very helpful dealing with my past and also to gain a new perspective on my current situation. On LSD I often dance to music while at the same time being able to think about stuff that bothers me and gaining new insights. It is also possible for me (more than on shrooms) to talk to others and share experiences which was also quite helpful for me.
MDMA: 10/10. Although MDMA is much more of a fun drug rather than a spiritual one compared to classic psychedelics, being on MDMA (and similar drugs like methylone and the like) together with my boy-friend probably enabled me to have a romantic relationsship with him. I am able to be a lot more open and trusting and talk about stuff with him that I would usually not talk about with someone who hasn't been through similar things and much less a guy. For example I could never really talk about what I like or dislike when having sex or why I often don't want to have sex. When my boy-friend tried to bring up the subject I always got mute. At some point he cautiosly started talking about it when we were both on MDMA and that was the first time I could talk about it, which in turn helped our relationship a lot.
Ayahuasca: 7/10 My experience is limited, as I only had one proper ayahuasca trip as part of a ceremony with a shaman. However, this experience was quite interesting and provided me with some interesting knowledge about myself. So I'd say it has a lot of potential. However, it is more complicated to take compared to shrooms and LSD as you need to fast beforehand.
DMT (smoked): 1/10: Fun, very colourful, but no insights like on ayahuasca, because the effect is quite strong, but lasts only a few minutes.
DXM: 3/10: I am mainly including it here, because it was the first psychedelic drug (other than weed) and as such showed me the healing potential that psychedelic drugs can have. During my first high dose DXM trip I left my body on my trip and had to trust a friend to make sure that nothing in the real world would hurt my body. As I struggled with severe distrust at the time, this was quite an interesting experience for me. However, I don't recommend DXM, if you have access to other psychedelic drugs, as the side effects are quite strong (like feeling really hung over the next day).
Ketamine: 5/10. It is fun and I feel less stressed for a few days or a few weeks after taking it. However, especially with higher doses I don't remember much about the trip. And ketamine can be quite dark sometimes.
Weed: 7/10. The drug I have used the most in my life (excluding caffeine). It causes my mood to be more stable (although as I grew older my mood also stabilised a bit by itself) and more mellow in general. Plus I can go to sleep almost instantly, if I consume indica dominant strains. And I don't dream or don't remember my dreams which is also a plus. I also really like the fact that on weed I can be happy just being still, enjoying nature and be in an almost meditative state. As I am naturally a person who always needs to do something and gets bored extremely easily it is nice for me to be able to relax a little. I only give weed 7/10, because it has a negative effect on me, if I overdo it: For a positive effect I can consume weed anywhere between 1 or 2 times a week to daily, as long as I take care to only consume weed shortly before sleeping on most days. So I still spend most of my (free) time not being under the influence of weed. If I consume weed multiple times a day or even just in the evening, but as soon as I am finished working or doing my chores, weed makes be unhappy and lazy.
Benzodiazepines: 2/10: There were moments when I was grateful to have benzodiazepines at hand, for example after barely being able to sleep for several days due to extreme stress + long distance travel + jetlag. On these rare occasions a one time therapeutic dose helped me to reset my sleep schedule. But they are certainly only to be taken as an emergency medication as the tolerance builds up incredibly quick and I experienced rebound anxiety even after just taking diazepame weekly for a few weeks. And I know quite a few people who have struggled with benzodiazepine addiction and the withdrawal is harder and more dangerous than the withdrawal from heroine or fentanyl.
I don't give detailed descriptions of other drugs I have consumed, among them different opoids, cathinones, cocaine, amphetamines, methamphetamine, alcohol, salvia divinorum, because although they can be fun I don't think they have any healing effect for me.
When it comes to negative effects the worst for me was alcohol, mainly because its negative effects on my physical health (like getting sick more easily or making a sickness much worse when consuming while sick) as well as causing me to become unhappy when I drink daily for more than a few days. Buprenorphine caused me to become violent, so I wouldn't take it again. Opoids in general also seem to have a potential negative effect in the way that they numb feelings and can induce dysphoria as soon as a tolerance starts to build, but I haven't really taken them long enough to have much trouble with these side effects.