I am giving a partial answer. Sri Ramakrishna says in Kathamrita:
Shakti is the 'Mulaadhara' ( basic preserver) of this world. In Shakti, there is both Vidya and Avidya. Vidya is that what takes one directly to God, yielding devotion, Compassion, Jnana, Prema. Avidya generates the bondage with lust and gold. That Avidya has to be pleased. So Shakti is worshipped. There are various ways of making Her pleased. Veera [stri]-Bhava means pleasing Her like ones's wife.(324 Aug 1882). This stri-bhava is not good. One becomes fallen from the spiritual path very quickly. Matri-bhava is the pure bhava.(14 December 1883).
He also makes it clear that He never liked or worshipped in that bhava and asked all not to walk on that path.
By the way, Veera-Bhava of Tantra is not necessarily related with this stri-bhava. In virabhava, some Tantras advice to meditate on the lotus feet of the Divine Mother instead of usig the fifth tattva (Maithuna). (Reference: Vrihat -Tantrasaara, Vasumati Corporation, 2nd ed, 12 th print, page 628.) Also, in the validaana-mantra of Vira-bhava, Goddess is referred to as 'Mother'. (Ibid page 352).
The practice Sri Ramakrishna is condemning is invoking Divine Mother in some female and please Her physically. Thats the path of Tantra. Bamakhepa told Promodkumar that He also practised it. Sri Ramakrishna has always treated all women as Mother and this is something unique for a Tantrik.
One other such instance is Swami Nigamamanda Paramahansa.His wife Sudhangshuvala died in her youth.Soon Nigamanandaji became a disciple of Bamakhepa. Devi appeared to him in form of Sudhangsubala after his mantra-siddhi at Tarapith Mahasmashan.Devi used to appear regularly every night to him as Sudhangsuvala.Later he engaged himself in yogamarga sadhana under Sumardasji Maharaj. (Reference: His biography in Bharater sadhak and his book 'Mayer kripa'.These incidentsare mentioned also in many places in the Nigamananda literature.
Nigamanandaji narrated another incident of a saint caalled Brahmananda who got the vision of Devi whike doing japa on a dead elephent.When Devi asked him to take boon, he asked Her to become his wife.Devi told him that this boon is not possible for Her to give as She is the eternal consort of Lord Shiva. She ordered one of Her Shaktis to become Brahmananda's wife and Brahmananda amrried Her.(Reference: Reminisences of Narayani Devi in Satarupe Arup Nigamananda (Inshall try to provide a photocopy of the exact pages).
In 'Sastramulak Bharatiya Shaktisadhana(RMIC, Vol. 2, page 624), Upendrakumar Das wries:
The second type of the Panchamatattva(Maithuna), there is a practice called Duti-yaaga. Sadhaka should first worship Duti after worshipping Shakti.(Duti means representative of Shakti).Then he should offer retas(semen) as havi to the yonikunda of Duti and get the grace of Devi.This type of practice is advised with sadhaka's own wife. It should be remembered that it is a type of 'homa'(worship by offering).
It is clear why Sri Ramakrishna did not like or advocate such practices.