In The Myth of Sacred Prostitution in Antiquity (Cambridge University Press, 2008), Stephanie Lynn Budin decisively argues that sacred prostitution never existed in the ancient Mediterranean or Near East (as she states very clearly in the very first sentence of the Introduction), and that the topic has suffered from millennia of misunderstanding, deliberate historiographic bad-faith arguments, and piss-poor methodology. Further in the introduction, she outlines the main loci which were, in modern and in ancient times, attributed to sacred prostitution, and a quick overview of the evidence of these. The scenarios include (roughly):

1. single-serve "prostitution", such as the "ritualistic deflowering" of a virgin in honor of a goddess (which, she argues convincingly, is not prostitution at all, since it is not an exchange of sex for money)

2. "temporary" or "expedient" prostitution, such as before marriage, as administered by a temple as a sort of sacred pimping proxy

3. professional sex workers operating on the grounds of, in the accounts of, and under the direction of a temple and its governing officials

One of the problems with this topic, which Budin both acknowledges and tackles, is that "sacred prostitution" spans disciplines. It requires proficiency in archaeology, art history, epigraphy, historiography, and philology, and stretches across not only different epochs within the Greek sphere, but also necessitates proficiency with the Near Eastern equivalents of these fields, also across time periods. Budin goes through it all, from the Near Eastern to the Greco-Roman to the Christian.

For a more condensed, nascent argument by Budin on this topic, see her entry in the 2006 volume Prostitutes and Courtesans in the Ancient World (University of Wisconsin), edited by Faraone and McClure. EDIT: see also this mostly positive but also cautionary review of Budin's book in the BMCR here.