I find this kind of statement to be rather offensive as you can imagine. So here is an extremely short list of of some people who most certainly are capable, ethical and valuable members of society.
“No culture in the history of the world, save the thoroughly depraved and expiring ones, has failed to affirm the existence of a Supreme Being. It is an empirical observation that men without a strong and lasting faith in a Supreme Being are less capable, less ethical and less valuable to themselves and society....A man without an abiding faith is, by observation alone, more of a thing than a man.”
Patrick Blackett: Nobel Prize winning experimental physicist.
Noam Chomsky: American Philosopher and father of modern linguistics.
Francis Crick: Nobel Prize winning biologist, co-discoverer of DNA structure.
Richard Feynman: Early contributor to the development of quantum mechanics.
Sigmund Freud: Founded the psychoanalytic school of psychology.
Democritus: Pre-Socratic philosopher who proposed one of the earliest atomic theories.
Sir Julian Huxley: Founding member of the World Wildlife Fund.
Ernst Mayr: Renowned taxonomist and evolutionary Biologist.
Peter Singer: Australian philosopher and humanist known for his works on Utilitarianism, strong advocate of animal liberation.
Richard Strauss: Famous German composer of the theme for 2001: A Space Odyssey.
There are many more lists availiable on the internet that are much more comprehensive than this snippet. Here is one such example. Wikipedia even has extensive lists of notable nontheists here. All I wanted to demonstrate was that Religious people are simply lying outright when they claim such things as L. Ron Hubbard did in the quote above.