There aren't any for FF9. Some work has been done on extracting and viewing models, but no mods have been released. Since there's no PC version, hacking is far harder.
The Mod category is indeed confusing, because not all of the mod releases are in there; the category was made recently and not all of the old threads have been moved.
Nearly all of the mods on these forums are for FF7. There are a few for FF8. It's also worth noting that most of the mods are for the PC versions of the games.
Out of all the mods that have been released, I'd recommend
gjoerulv's hardcore mod. It doesn't change how the game looks, but it improves the gameplay and makes the enemies put up a fight. There are some new bosses, too.
If you want graphics mods for FF7, you may also wish to look in the "Team Avalanche" section. It's a work in progress, but some superb textures and models have been made.