But of course there are other values other than just instant profit. The next release in the franchise will get a boost if the previous one was well received.
The only real complete figures I've found so far were Gears at a little over $10M ($10M + engine development, but that's of course just not for Gears) and Spiderman 3 at $35M.