chollie

I just came back on the A330 from AMS in Y. If you get one of the emergency exit seats (row 10, avoid the window), you'll be pretty comfortable. Good IFE.
Don't know about DTW as a connection, though (never been through there).

Leg room and IFE are important to me when I fly (even if I have to accept a connection).

You might also want to check the thread about the new 'economy comfort'. I think the 767's are getting done already. Don't know anyone who's flown an updated 330 yet and don't know if 747's are getting done. That might sway your decision - lot of leg room, especially in the bulkhead seats, and supposedly more (double) recline.