I don't think anyone has mentioned the Katamari series yet, but I think it's worth highlighting, as the games have some really pleasing low-poly models.
Here are a few quick shots I took from Katamari Damacy (emulated).
The flat lighting and the low detail, pixelated textures were a great choice, even if it was partly because of hardware limitations.
Some of the filters used in Katamari Forever (PS3) make the art look even better, but I'd imagine the games would also look amazing with really high quality lighting (for example, in the OP).
Another great example of pleasing, low-poly art would be Ghost Trick; the characters are not sprites, but rather 3D models.
EDIT: As it turns out, the Ghost Trick characters are indeed sprites, but were originally 3D models which were rendered in 2D.