As someone who nearly got murdered in their sleep by someone on one such ketamine-caused psychosis, I think that caution is warranted when prescribing it. Waking up to take a knife away from a crying person is not something I would recommend to others.
I've heard that there are studies on a metabolite of ketamine that's supposed to avoid the psycosis. I really hope that works so we get something this powerful without the downside.