Multi (Evaluative) works very well for the majority of the time.
I'd use Spot metering in difficult lighting situations, something small and light against a dark background, the Moon for example, or vice versa.
I personally would probably never use Centre Weighted because I don't have a great deal of experience of it. For someone who has 10-20 years experience of using Centre Weighted metering may use it because they know how to read the scene and compensate in different situations. :shrug: