Some games that haven't been mentioned here:
Europa Hazard: really nice 2D art, but the game itself was generic and empty.
Nightclub: great renders and special artstyle, but alas, abandoned
Cyra's cove: really nice art, but made in Unity instead of something sensible like Ren'py
Au-pair innocence: decent 3DCG renders, but completely ruined by the generic point & click mechanics while having an empty world and the dev focusing on the cuck content
Edit: just read the list posted earlier in this thread and
Holiday Islands is also worth mentioning. The open world mechanics were properly designed and it has some nice-looking characters, but it never really gained support and did stupid things like adding the ugly goblin girl from Dating my daughter.