The Mayor's House acts as a large park in that it tremendously increases desirability for both residential and commercial population around it. It may be the most worthwhile out of all the business deals.
However it does have a slight positive effect on commercial desirability and, interestingly, increases the industrial manufacturing demand cap. The Army Base is another producer of radiation (even if not much). It does provide quite some income, though. The Toxic Waste Dump generates huge amounts of pollution, including radiation, which means it cannot be built anywhere near civilization since Sims abhor radiation. This makes it a quite risky business deal to utilize.
However, there's a chance of a misfire, which can hit the city and destroy several buildings. The Missile Range easily provides the most income of all the business deals. However, it does act as a larger jail in case you need the capacity. The Federal Prison should be kept away from residential areas as it has a tremendous effect on residential (as well as commercial) desirability. While it does increase commercial desirability around it, the crime mostly negates the effect. The side effect is that it acts as a huge magnet to crime, on top of the crime increase caused by the ordinance. The Casino can only be built if Legalize Gambling ordinance is enacted, otherwise it won't be available.
