Just so there's another opinion: I have shot lots of flower macros (documenting the wife's gardening efforts) over the years handheld with ISO 100 slide film. A tripod is always nice, but not always necessary.
Originally Posted by Christopher Walrath
Now, having said that, I use a tripod or even a copy stand for a lot of indoor macro stuff, but outside in bright sunlight, it's possible to handhold.
I wouldn't say that any particular film is better for macro than your other shots with the same camera. You might prefer a different film due to the subject matter, but not to the "macro" part per say.