I've written a lot of lisp, including a respectable number of macros, and I don't think I've ever been caught out by hygiene. I've definitely written broken macros that expanded to the wrong thing though.