The F-14, for example, a much longer range than the Super Hornet,
This is not true.
F-18E has 1660 nm of ferry range with two sidewinders (missiles retained due to aerodynamic advantage) and three 480 gallon tanks, all three retained. (as per USN website fact file)
F-14D (the later more capable variant with decent engines and some multirole capability near the end of its service), carrying two 280 gal drop tanks and no missiles (retaining the tanks) has ferry range of 1591 nm. (As per Navair 1985 document.)
Dropping the tanks for F-14 when empty would add nother 80-ish nm, as they represent some 19% of total initial fuel carried.
For F18E, carrying three larger tanks means 39% of initial fuel is carried in tanks. So not dropping tanks when empty costs F18 even more, and F18E would add another 140 nm if it drops tanks. (as per F4 Navair document, since f4 has similar fuel ratios, dropping its tanks and gaining that much ferry range)
F18E also has options to carry less weapons and more fuel, carrying four tanks if needed, for a bit of extra range. (though at that point the extra 20% of fuel would hardly translate into even half of extra range) (five tanks, while possible for F18E, is from what i read, not really used)
So ferry range difference would roughly be 1670 nm versus 1800-1900 nm, in favor of F18E.
Operational range, carrying 6-8 missiles, would lower the difference but F18E would still likely not be much behind F14D, if at all.
F-14A did have longer range than F-14D, but with other drawbacks, and it really wasn't a multirole plane.
F-14 is simply not a terribly efficient design by today's standars. almost 20 tons empty and almost 34 ton MTOW. Comparing that to Rafale M's 10.2 to 24 tons and Superhornets 14.5 to 30 tons.