What does it smell like when cats spray?

This varies greatly from one cat to another. Generally, though, the smell is very faint -- you have to get your nose right close to her fur -- and is a sort of a dry, sandy / spicy smell.

Note that older cats can suffer from low-grade oral infections and caries, and can have very bad breath.