For some reason, I'm impressed whenever anyone does anything clever in ASM, even if the performance benefits don't add up to much these days.
If you want to feel impressed, check this out http://benfry.com/distellamap/
I don't think I've seen any assembly that was actually enabled in the games I've worked on in the last five years, though I do know where there's a tiny bit in my current project that's #if'd for older environments. That's just stuff like atomic operations that every modern compiler provides built-ins for now.
The link is great, thanks!