Mark _australia said..Polished is slower..... so so much testing on that.
Mclube are trying to sell you something.....

Sanded is faster. However i doubt anyone can feel the difference between 800 and 1200 or 1500 on a foil
Boardlady used to recommend just 600 on the bottom - she used to be a naval architect (building racing yachts) before her board repair career. But echoing everyone else. Hydrophillic 100%. Even a bit of something greasy (hydrophobic) on a foil like a tef-gel fingerprint is noticeable (ventilation near surface so much worse). If water beads up, start sanding/cleaning. Anything much above 800 is for your OCD as Mark says. I think one of the major foil brands does just 800.
For fins and foils, having water attached not only reduces drag but also inhibits separation making spin out and ventilation much less likely.
As for sanding, she says circles. Some foil makers suggest parallel with water flow, others perpendicular.
boardlady.com/fast.htmI've seen research on drag for ships, etc indicating that a surface roughness of the equivalent of 200 grit sandpaper the lowest drag. It may be at our higher speeds that smoother is better and I'm not going to be the first to sand my board with 200 but it goes to show that slick and shiny doesn't really work in water at our speeds. (I've also read an anecdote from a high level foiler that sanding scratches out of a wing with 200- it was the only thing he had with him - in the car park made his foil behave better and still allowed him to hit 35ish kts.)