Manifest it!
I think AVNs/lewd games are just like anything else - lots of people think they want to try it, but only a small % of those who do have the business sense and patience and long-term commitment to finish a game.
I have drifted more to DL-ing games that look interesting and trying them out - just to filter out anything where the writing or mechanics are crappy - but then just making a notation as updates are released but not DL-ing anything more until the game is marked complete (excepting games I love). So I get invested in a lot fewer games, but I probably have saved myself a lot of disappointment too.
Restaurants famously fail at a 90% clip in their first year - I don't really see AVNs as very different than that (other than the timeline being a bit longer than 1 year). And honestly with constantly changing technology keeping a game that runs for more than 2 years 'fresh' is even harder than restaurants (food is food), since after 2 years a dev can look back at the early updates and get bummed at how outdated the graphics look, at which point many get caught in the endless whirlpool of 'remakes' and never progress with the actual story. It's a hard thing to do, a harder thing to finish, and hardest of all to do well AND finish. It really takes a warrior's mentality.