It's way more stylized and complex than The Silver Case was which is pretty surprising. A lot of that complexity comes from connecting very vague story points across the game. That could be a negative but it's intentionally ambiguous in the beginning, putting it together and getting the full picture is part of the fun.
Some of it did feel pretty unnecessary (mostly Matchmaker chapters) but the characters in the 25th Ward as it was fleshed out felt iconic and often sombre in their stories.
I'd say the original Silver Case is slightly better to me but The 25th Ward is extremely close.

I'd also be remiss not to mention the music. It's great.