To counter your anecdote, I've also received ketamine sedation for procedures, and never have I experienced any sort of "tripping"-like effects. It certainly can be used without those effects, at least in some portion of the population.