Which games are at the other end of that spectrum? I'd probably have to say MMOs.
Yeah, but this is Square Enix we're talking about. They don't let minor details like that prevent them from making the most detailed flower pots MMOs have ever seen.
Not to mention Square Enix has a tradition of making the world's crappiest PC ports. Final Fantasy XIII launched on the PC supporting 1280x720 - and nothing else. Pressing Escape while the game was running instantly quit you out of the game without confirmation. The reason for this became obvious when they tried to add a confirmation dialog - the confirmation dialog wasn't done in-engine, meaning that pressing Escape appeared to lock up your game until you Alt-Tabbed to another app and could see the dialog box.
Square Enix can create some impressive graphics, and they can create games that run well on consoles, but their PC track-record is absolutely abysmal. (Keep in mind I'm only talking about games Square Enix themselves made for PC, not games other studios made that they published.) No matter how pretty their tech demos look, you can be sure that whatever they finally create will be unplayable on the PC.