It definitely reads like a race condition, I am not sure how to solve it though. I know I am not the only one with this need, (How to manage multiple Email with different assignment agent - #3 by Prasath_Sekar is asking for similar). I am open to suggestions on how to troubleshoot and fix this. This is the final hold-up for us to go live.
Does “Before Insert” sound like the right trigger? Like I said, I tried most of them, but since this is most likely a race condition I am looking for community thoughts here.