It seems to me that the difference is not so much 'where those people are put' but rather that there are support mechanisms that help the majority of at-risk people before they deteriorate to the level of homelessness or mental disability that you commonly see in US city streets.

EDIT: While there are obviously outlier cases where treatment is difficult, the majority of mental illness and homelessness is circumstantial and preventable.