In case you like data instead of anecdotes, here’s a link to studies of the effectiveness of Housing First programs: http://whatworksforhealth.wisc.edu/program.php?t1=109&t2=126&t3=89&id=349
I haven’t read any of these studies. There are a lot of them though.