One of the reasons I couldn't stand DS9 much was because of it's religious undertones.
Undertones? The Prophets exist
, and are capable of communicating with arbitrary individuals at will (although they don't do so often). It's entirely reasonable---scientifically speaking---for the Bajorans to have structured a belief system around them.
The question on DS9 wasn't whether religion is "real"....it clearly was. The question was whether that's a good thing or a bad thing for a society, and even perhaps a bit of both.