As far as I know the STTC-847 or the SMTC-0147 is what you seek. Never used those tough.
Here some links for you:
SMTC HOOF
http://www.metcal.com/metcal/english/globalnavigation/products/hand-soldering-systems/tips-and-cartridges/mx-cartridges/smtc-series-hoof
STTC BEVEL
http://www.metcal.com/metcal/english/globalnavigation/products/hand-soldering-systems/tips-and-cartridges/mx-cartridges/sttc-series-bevel
I've done a lot of drag soldering with Metcal MX-500 at a previous job, but I can't remember what tip model we used.
According to SteveyG the 'hooof' type SMTC-x147 has a concave fillet, which is good for providing high solder retention capability for drag soldering.
And from what I remember the profile of the drag soldering tips we used looks also looks like SMTC-x147:
They must be called hoof tips because they resemble the shape of a horse hoof.
I guess the difference between 'hoof' and 'bevel' tips is that bevel tips has a flat solder surface while hoof tips has a concave filling, providing high solder retention capability?
Btw. I also find the hoof tips the best for tips tinning stripped wire ends, because they can hold a lot of solder. It works better than a chisel tip for this.
However John Gammell just use a flat bevel tip in this video
Not sure why he doesn't use a hoof tip with concave filling? I would think it would be easier to use as it can hold more solder with the concave filling, so you don't have to feed solder while dragging. Just remeber to add flux to the pads before drag soldering ad the flux in the solder quickly vaporize when you put it on the tip before dragging. Adding flux also makes it much easier to drag the solder from pad to pads without making any unintentional solder bridges between pins.
I see he use a 60 degree angle Hakko T15-CF3 bevel tip for drag soldering:
http://www.hakko.com/english/tip_selection/series_t15.html#type_bc_cBut Hakko only make the "Shape BCM/CM" hoof type tips in a 45 degree angle unlike the flat bevel types in 60 degree angle, like the Metcal hoof and bevel tips. I think it's much more comfortable to use a 60 degree angle tip than 45 degree for drag soldering.
Another tip we used a lot for drag soldering is the knife tip, but this was for drag soldering PLCC-chips only.
For most other drag soldering like SO-chips, the hoof tip is better.
I can see John Gammell also use a hoof/bevel tip for drag soldering PLCC. He has just turned it upside down, with the solder facing the chip instead of the pads:
It looks like this also works fine, but I haven't tried this. We always used knife tips for this instead and just tin it on both sides and drag it in a 45 degree andgle between the pins and pads.
I don't think the hoof tip would have worked as well in our case as there was very little rooms around the PLCC, and it's easier to get the knife tip in a proper angle on PLCC tips in tight spaces.
But unless you solder a lot of PLCC chips there's usually no need for this knife tip. I have replaced countless PLCC-chips because the developers didn't bother to use a PLCC-cocket because it only had a simple firmware that never needed upgrading. OF course they later found a bug in this simple firmware which meant we had to replace all of these PLCC chips to upgrade the firmware when these products came in for repair.