I never cared much for the overarching story of the games I'm only in it for the mystery solving and characters. V3 was actually the only ending I didn't hate. I thought it was a cool interesting twist.
It will suck though if the series is completely over though. I don't think they've completely written themselves into a corner but it will be hard to move on.