He didn't want to make the X-Men movies either, he cut the budget on the first one and moved forward the release date because he thought X-Men sucked.
The thing was though that Fox never lost money when he was in charge, they missed out on making a lot but he didn't rock the financial boat.