Static IP is better for games, for starters. Also necessary for private torrent trackers.
Dynamic is good for changing IP to get around data limits but that's about it. What security reasons?