I too have 007 Agent Under Fire lock up on a black screen. It was at the end of the car chase level after James Bond was presented with his new car.
I have cIOS38 rev17 installed, MIOS patched with WiiGators MIOS patcher based of MIOS v4, NeoGamma r9 b26, ISO burned to a 1:1 single ISO disc. NTSC version of the game on a USA Wii.
the second time I played it I noticed that just before it locked up, to a black screen at the same exact spot in the game, the skin tone of the the people and the fire of the car burning was colored blue.