I think at this point I am bragging that I have never written one. Ok, I have used views of views, but.......
I have, however, had the misfortune of troubleshooting those 10 page queries. Finding a stupid typo in one of those is like looking for a needle in a haystack.....
I'm looking at a query here that is 37 printed pages, with 92 joins over 25 unions.