There is no "latest" James Bond game on Wii. The final 007 title released for the system was:
A reimagining of the N64 classic, developed by Eurocom, published by Activision.
If you have a Wii, GoldenEye 007 (2010) with Wii Remote Plus + Nunchuk is the definitive way to play Bond on that hardware.