> I've also heard the opposite, that it leads to absolutely nothing and you are kind of treated like a PhD dropout, at least in the US.

Students who do a Master's before going on to Ph.D. are usually more competent and more useful to the university. This is FUD created by graduate students to prevent competition.