I know most if not all of these are not the final games released but were in the twilight and just before or just around the time a successor came out.
PS2. Okami,FF12,DMC3
PS3. Strider. Metal Gear Rising. Dragon's Crown. Lost in Rain. EX Troopers
PS1. Final Fantasy IX. Vagrant Story. Mega Man legends 2. Strider 2.
Vita. Macross Delta. Uppers. Soldner X 2.
PSP. Ys I & II Chronicles.
Wii. The Last Story. Xenoblade.
SNES. Earthbound. terranigma. Front Mission Gunhazard. Metal Warriors. Super Mario RPG.
Wii U. BOTW.Tokyo Mirage Sessions.
DS. Solatorobo. Dragon Quest IX. Infinite Space.
SEGA Dreamcast. Shenmue. Ikaruga. Rez. Fighting Vipers 2.
Saturn. Bulk Slash. Burning Rangers. Panzer Dragoon Saga. (best Dragoon RPG ever) Shining Froce III. Princess Crown. Radiant Silvergun.
Genesis. Monster World IV
Xbox. Capcom Classics Collection. Castlevania Curse of Darkness.