This one didn't get many good reviews at the time, but I loved it. Become James Bond (who at the time meant Timothy Dalton) and move trough several Bondian scenarios, with lots of jumping and shooting.
IMHO, this was the best James Bond game available until "Goldeneye" for the N64 came around.