I've actually used INTERSECT and EXCEPT quite a bit, not as a replacement for inner joins as some of these comments imply, but to simplify the comparison of two complex resultsets.

I've also used INTERSECT as a performance tweak:

http://www.real-sql-guy.com/2011/11/stop-performance-problem-with-intersect.html