I flew the F-14 (A and B) and the F/A-18 C... Never flew the Super Hornet (E and F model)...so I have no first hand experience with the jet.
But here's the real question: what missions do you want the airplane to perform? If it's long range high speed intercept of invading bombers, there are better choices (the F-15 would be my pick... and the Avro Arrow was designed precisely for that mission back in the late 50s).
If you want a reliable, effective multi-mission airplane, the USN has had great success doing close air support and interdiction in combat over the last 11 years with the Super Hornet.
It has some performance parameters that are lower than older airplanes, like top speed, but in lots of ways, most in fact, it's superior. More flexible, reliable, better handling, more ordnance capacity, more endurance. It's a good all around jet.
Given Canada's budget and deployment record the super hornet is a good choice. I wouldn't go with JSF for example, Canada wouldn't be likely to need the stealth and the airplane costs nearly twice as much..,