This has nothing to do with find, but with how shell glob expansion works. If unmatched, it passes the argument as-is. If it matches something, it expands right away. It is made worse with the way find works, but this is shell-101 (just like not doing `rm -rf $FOO/` is).
FWIW, just seeing the title, this is what I expected to read.