I've used silicone spray on any part that moves, as I that's what I have. Seems to work ok.
I clean the whole sunroof area out regularly - dust, grit etc.
I clean the 'felt' surround with APC, especially if any green shows over winter - and again, lubricate with silicone spray.
I use the roof almost every day and it opens/tilts with no problems.... so far!
I would be keen to see a pic of where the drainage hole is, as I can't find it!