It definitely hasn't aged well.
It never was good. The mechanics were horrible, and I just hated it's story. I'm of split minds about the PS3-360 version of Double Agent as well, I didnt enjoy all of the daylight missions. I prefered the night time 'try to keep stealthy' style, in the daylight was aweful >: (
Though I do admit, that mission Hong Kong (I think) at that hotel is pretty awesome to me.