Dragon Quest V and VI are both for the SNES. They were never released outside of Japan, but there is a 100% complete fantranslation of DQV and a 96% complete fantranslation of DQVI that can easily be found through a google search. Both of these games, as well as Dragon Quest IV, are also being remade for the DS though so you may want to just wait for them (the DQIV remake is being released in Japan in december). Dragon Warrior VII is for the playstation. It's too slow moving for my tastes, but admittedly I've only played 4 hours of what is supposedly a 150 hour game (one of the longest JRPGs ever made).
This has some pretty decent information on Dragon Quest IX. There was also a great trailer on YouTube from 2006, but the game has changed from an action RPG back to a more traditional turn based RPG since then so the footage is pretty redundant now.