Another one I've seen a few times with find (although it is actually more an xargs thing than a find thing), usually not with any bad consequences at least, is something like this:
find . -type f | xargs grep foo
You expect to see all the "foo" lines from your files, each prefixed with the file name and a colon. And that's what you get most of the time.
But sometimes you might get a foo line without the filename prefix.
Why? Because grep only adds the filename prefix when there is more than one filename argument. There are two ways that might come about in the above command.
The first is if the find only finds one file.
The second is if the find finds so many files that xargs has to invoke grep more than once. It can happen that there is only one file left to do when it gets to the final grep invocation.
Simple fix:
find . -type f | xargs grep foo /dev/null