I disagree, there really is no CF park that is in need of a hypercoaster.
Michigan's Adventure - At this time to small/low attendance to support a ride of this caliber.
California's Great America - Could use a hyper, too risky to install such a large ride due to the park situation. Plus the city would never allow it.
Knott's - The only viable option I see, I agree this ride could have been meant for Knott's.
Every other Cedar Fair park has a large hypercoaster of some type. The only other park I could see this going to would be Worlds of Fun. We have to remember though that Cedar Fair is out to make a profit, having this coaster at WOF would probably not be very profitable for the company. CW on the other hand will generate a huge profit.
Canada's Wonderland and King's Island seem like great choices for a ride of this size. The goal of CF is to bring in paying customers, not to please coaster enthusiasts. From a business perspective this is a great move IMO.
TL;DR: Behemoth was a huge success for CW, why not build an even better one to bring in more people?