Hi,
Alphasim have got some good stuff, I've got the Phantom and Sea Vixen and they're very good. Unfortunately the Phantom doesn't have an arrestor hook so you have to stall it onto the deck. The Alphasim Buccaneer only works in FS2002 which is a shame. There is a real lack of Fleet Air Arm Aircraft for CFS2, I'd like to see a freeware Sea Fury, Wyvern, Firefly, Gannet (sounds like there already might be one), Sea Hornet, Sea Venom, Sea Hawk, Sea Vixen (although the Alphasim one I've got is very very good things are better when they're free!), Scimitar, Buccaneer and a Phantom (with arrestor hook) of 892 NAS.

Hi Will. I take it you're talking about payware. Alphasim very generously posted a lot of their older files as freeware, including a RN Phantom & Buccaneer.
http://www.alphasim.co.uk/DL%20Freeware.htm These aren't the same quality as the proper CFS2/FS2002 stuff but they're worth checking out. There's also a very nice CFS2 (or FS2000) Buccaneer posted somewhere, maybe at SimV.
You can give any aircraft a virtual tailhook by adding the entry to Aircraft.cfg. This won't affect the visual model. Here's the entry from the CFS2 default Corsair which should do fine. You can adjust it to suit if you wish.
[TailHook]
tailhook_length=4 ;(feet)
tailhook_position = -15.0, 0.0, -1.0 ;(feet) longitudinal, lateral, vertical positions from datum
cable_force_adjust = 1.0