The corners where Wikipedia breaks down are niche but fascinating. Check out the list of superhero movies (not Marvel or DC). Or any page that contains information on Video Game Console Generations.

In cases like those, what has gone wrong is a mix of apophenia and people protecting their own turf. Elaborate classification systems are created that are internally consistent but have no relationship to reality.