In article ,
Duncan Adams wrote:

Can anyone shed any light on this please? Perhaps point me at a likely
culprit amongst the cacti and succulents (we have many varieties)?

Do you have any stapeliads? Stapelia spp in particular are called
'carrion flower' because of the putrid and/or sewage-like smell of
their flowers, which are fly-pollinated.