I found the visions/hallucinations terrifying. I did get some mood improvement from the infusions (not the nasal spray, though). Unfortunately, my improved mood fizzled after a few days. A combo of IV ketamine and transcranial magnetic stimulation (TMS) gave me some relief for about a month. That kind of treatment isn't sustainable, though. On top of being crazy expensive, you do literally nothing else for the duration of treatment, which is like 4-6 weeks. You can't—you feel like a wrung-out washing rag afterward.
Edit: There is some robust trial data on ketamine. There's less on ketamine + TMS, but it looks very promising. This forum isn't really where you go for treatment success stories, though. I second the idea that asking this question in Recovery might give you more of what you're looking for. Unless you WANT to read: "It failed." "Failed here too." "Rated F for 'failure.'" :p