They're all over the place for core functions - whenever you click a "Share" button it will ask which applications can handle the content you want to share and add them to the menu. I've also been prompted to choose whether I want to make phone calls using the built in dialer or Skype, which I presume is using intents as well.
Where I've not see so much use is providing completely new intents, presumably because its so hard to get any sort of agreement on how they should be implemented.