Cannabis: Wonderful in extreme moderation, (1-4times/mo), a lot of creativity, mild synesthesia, playing music is a lot nicer (incredibly so - the synesthesia helps)
Unfortunately, even at such moderate use, hangover the next day.
MXE: Wrote about it recently (see here). Fascinating substance.
Phenibut: Little gem. Very subtle, and it will only ever kick in if I don't eat 3h before and after consuming it. Great for socializing, great for practicing anything.
More creative, some euphoria/bliss, very minor visual enhancement.
Does wonders to music too, though I don't care too much to actually play on it.
MDMA: Incredibly special. One of my favorites, even today. Limit it to 1-2 times a year, every experience is magical, as good as the first time.
Have done it solo twice, incredibly therapeutic. If with company, it has to be the right people (open and caring), or there's a block.
Amphetamine: Amazing with no tolerance. Don't really do it often at all - it cannot be sustained.
Modafinil: For when I need to be awake and sharp and have not slept very good, as a last resort (if there's something really important to do). After about half an hour, the tiredness/mental fog will disappear completely, and I feel as if I rested well - this is on 25-50mg, 100mg is too much for me, too wired and unemotional.
Tramadol: Tried it a couple of times, fun times, but concerns about seizures (though I never had any) plus very quickly mounting tolerance resulted in eventual disinterest. It was fun though.
Alprazolam: Tried it two times to get an idea of what a benzo feels like. Disappointing, could have been the dose though. No desire to repeat.
Beta-blockers (bisoprolol): Extreme, clearly artificial calmness. And a 40 BPM HR. Could be useful for public speaking on lower doses, in fact I read some people do indeed use it like so
Plenty of interesting stuff out there, besides the psychedelics.