Some of these books are indeed trash, many have advice that's inapplicable to most people, a lot are based on anecdotal evidence, but some of them are alright and I read them and every once in a while I get something valuable out of it.

I think if you set your expectations right (e.g no book will make you happy / rich / whatever) they can be quite useful.