well, me and my brother together own nearly all the major consoles since the spectrum (exept the X-box, i hate microsoft games division two much) (oh and the master system 1, its rarer than gold). my suggestion would be the Snes as it rocks, but seeing as you want a latest gen console i can't say that one.
from the kind of games u want, i'd say gamecube. my brother owns one and he likes it. plus Zelda - the wind waker is out in america. (not over here yet though, dammit).
although the PS2 does have devil may cry and, as Angelousss said, you can play FF7 and tactics (if you can get hold of a copy of tactics, i haven't so far

)
also angelous, FF8 wasn't that bad. some people (including me) liked it alot. mainly the Avid FF fans. and just becuase i can personally name all the people that liked that game, doesn't mean it ain't good [img]smile.gif[/img]