I've tried asafoetida in the base sauce, but found it tends to get swallowed up (if you'll pardon the pun!). I've had greater success using it in the final dish early on - about 1/4 -1/2 teaspoon.
I think it adds something along the right lines. I don't personally find the smell repulsive, and I find it mellows quite a lot when cooked. For me, it's the smell of poppadoms. I often wonder if it's used in the making of them.