I use ketamine for depression. I get it by IV every 2-3 months at a clinic, and the effect seems to last about that long. Haven't had any bad side effects so far.
You're right that it can basically turn off depression, though. I just want a version with that and not the rest.