Here's an overview of his roles in recent projects (based on interviews, the Nintendo Sound Selection series credits, and a few other tidbits of information):
- Super Mario Sunshine - Composed a large portion of the score and most of the catchy compositions. Shinobu Tanaka of Mario Kart fame composed for most events and latter stages (e.g. Pinna Beach Park, Noki Village, Sirena Beach, Pianta Village). I find them boring.
- The Legend of Zelda: The Wind Waker - Kondo took a supervisory role while Kenta Nagata, Hajime Wakai, and Toru Minegishi handled the rest. Kondo was the smallest contributor, but he still created original compositions like "Graaandma" and maybe "Farewell Hyrule King". Nagata seems to be responsible for defining the sound of the nautical sound of the game with themes like "Dragon Roost Island", "Title", and probably the ocean. Minegishi probably handled a lot of the battle and dungeon themes while Wakai's cutesy Pikmin footprints are all over the score (e.g. "Forest Haven", "Wind Temple", "Kalle Demos").
- New Super Mario Bros. - Kondo created the very catchy main theme for the game while Asuka Ota and Hajime Wakai the rest of the material. I prefer the score to Super Mario Bros. 3 actually, though there is some filler.
- The Legend of Zelda: Twilight Princess - Toru Minegishi and Asuka Ota handled most of the pieces here, but Kondo was also a composer. He might have created more compositions that The Wind Waker despite being the smallest contributor; after all, it's a phenomenally large score. Anyone know more?
- The Legend of Zelda: Phantom Hourglass - Nagata, Minegishi, and Kondo returned. Wakai perhaps thankfully didn't. I doubt Kondo composed much for this score although there are a lot of reprises of his work.
- Super Mario Galaxy - Provided musical direction on the project, deciding upon a symphonic sound for instance. Created the four compositions mentioned above.
- Wii Music Orchestra - Both Kazumi Totaka and Koji Kondo seem to be composing for this project.