Yes, housing first is extremely effective at getting homeless people off the street. It's also the cheaper option.
Harm Reduction is a sham, its why SF is the way it is.
Simply giving people access to free needles does nothing for the actual problems - unabated drug use.