And out of all of that one series is good, I think I heard the dreamcast game is decent and the movies...are not the best ways to get into the series (I like the third movie though). It's bigger than niche yes, but it's definitely mishandled outside of the manga.
I'm not about to defend the 16/17 series even though I did kind of enjoy it, but I'd say all three games are actually pretty solid.