Fred is called by the government to go after an evil organization called The Grey Goose as he bears a distinct image of their top spy, Rock Slag. I liked the ways they uses to poke fun of the spy genre, particularly the James Bond films, which is what made the film entertaining to watch. The spy sequences were definitely the most fun to watch. As for regular Flintstones comedy, it could have been a lot funnier, as the traditional slapstick that made The Flintstones hilarious really gets tired after a while. I also could have done without the musical numbers, which drags the pacing down, especially the ones sung by Pebbles and Bamm Bamm.
Final consensus- The Man Called Flintstone is entertaining in poking fun at 007, but it could have been a lot better in making a strong Flintstones movie.