Economy
The A330s have the benefit of having a 2x4x2 layout in Economy, which means if you can bag an A/C or H/K seat then you either get window or aisle, no middle seat which is good. The layout on the -300 aircraft is different to the -200, with Economy Delight rows starting at 49 for the centre and 51 for the outer rows. Personally, Ill always take the A/C or H/K seats, but there is only one row in the centre, which is row 49 the bulkhead row. The downside to the bulkhead is that the tray tables are in the arm rests, resulting in narrower seats.
One of the big benefits of the Economy Delight cabin on the A330-300, is that it is towards the middle of the plane, meaning youre quite far from the bassinet positions, meaning less chance of a crying child in the vicinity of your seat.
Best seats for sleep 51A/C
Best seats for couples Any A/C or H/K combo
Best seats for a quick exit 51C
Premium
The nice thing about the A330-300 over the -200 variant is that it has been a staple of Virgins fleet for quite a while and has an almost identical Premium cabin to the 787-9 with the exception of the additional row of two seats towards the front left of the cabin. These seats are closer to the galley but offer additional privacy. The seat is slightly different on the 333 vs the 789 too but a lot of people wouldn't notice.
The bulkhead row, 19/20, cannot be selected online due to the bassinet positions and can only be assigned at the airport, so be nice to the check in staff if you want those seats! (Or ask in the Clubhouse and they can get them unblocked).
Best seats for sleep 25A/C
Best seats for couples Any A/C or H/K combo
Best seats for a quick exit 19A/C or 20D
Upper
The good thing about the A330-300 has an almost identical Upper Class cabin to the 787-9.
Best seats for sleep 3A, 4A, 5A, 6A, 7A
Best seats for couples any G/K combinations
Best seats for socialising 10A, 11A, 9G, 10K, 11K
Best seats for a quick exit 10A, 11A
I took this from an article I wrote on the subject not long ago. Naturally, there is a lot of personal preference involved.