So who's the hero that's going to play it and tell us how it is?
It can work for storyfags, at least the second title.
Coteries of New York has optional questlines (can do 2 out of 4 on a single playthrough) and the most reactivity. You can select out of three clans when making the character and that adds a some flavor as well but your character is a vague blank slate. There's some opportunity to perform suboptimally and it results in learning less about the characters through dialogue. But the entire thing is very bland, as if they didn't actually have a story to tell. If you're starved for VtM content then maybe it could work. The ending is railroaded, chaotic and disappointing.
Shadows of New York has the strongest writing, mature characters, a well-defined and interesting protagonist, and multiple endings. Watch
some LP for the first and maybe second episode to see if you actually enjoy the protagonist's internal monologue. There are returning characters from the first title but back in Coteries they were very sparsely defined to the point that you've barely learned anything about them and thus don't need to play it first. Both endings are pretty good in their own ways (your choices add up resulting in either one of them).
Reckoning of New York is made for zoomers. All the subtlety and nuance of characterization from the previous two titles goes out of the window. The returning characters behave like fools to make the story work. The whole thing doesn't have reactivity beyond affecting the next few 1-3 paragraphs after making a (fake) choice. The ironic edgy insecure zoomer narrating the whole thing in the first person is particularly grating in the beginning (there's even extremely-online slang appearing such as "yass queen", I kid you not) but then it mellows down a bit. However, the production values with character portraits and backgrounds are the highest. They're using light and shadow to good atmospheric effect much like Bloodlines. See the image below, no spoilers.
However, there's some blatant virtue signaling. Particularly in Shadows there are some 2-3 cases of really jarring injection of liberal identity politics. You might want to avoid giving the company any money, but the second title is worth getting on the high seas.
With games nowadays I rarely get the vibe of regretting that the story has ended (think PS:T, Witcher 1) but Shadows of New York actually clicked for me.