One of the best talks I've attended in my life was given at Schiphol Airport during the AmsterdamPHP Meetup by Jeroen van der Gulik. But his talk was about a much bigger problem than mine and he talked about how Apache Kafka helped him through this journey. The legacy project I've been working on is nearly 10 years old and packs a tremendous amount of technical debt.
The spaghetti code in combination with extremely dynamic execution makes it overly complex to make a reliable decision of when a domain event happened.
What made me more accepting of using triggers was trying to set them up as a dump event sourcing.