Layover stations:
HNL, LAX, GRU, GUM, TAS, JED, ULN, BKK, CNX, HKT, SIN, CEB, DPS, CGK, DAD, HAN, SGN, NAN, MLE, BOM, SVO, LED, BNE
Depending on season:
ZRH, MAD, PRG, TLV, SYD etc.
Night stops:
NRT, KIX, NGO, PUD etc.
Most places of less than 7 hours flight time (read: south-east Asia) will be 24 hours layover since we have daily flights, however many A330 destinations only have 3 flights a week which means you'll have either 48 or 72 hours there. Examples are MLE, NAN, LAX, GRU, BOM, JED, TAS, SIN, CGK, CNX, ZRH, MAD etc.
I would say that roughly 30% of the hotels are good/above expectations, 60% are average/acceptable and 10% are below average, but this depends on personal preference of course.
Overall the A330 is a good fleet to be in due to the good mixture of short/medium/long flights, and the good chances of getting long stays.