Packages that cannot be accepted upstream: themes, icons, fonts, packages that are "too new" (think Zig 0.16 for example), anything that packages binary blobs, anything that maintainers refuse to accept like Brave browser, or even your own tools.

Just off the top of my head. The reason I started that repo in the first place was to get a Noctalia package that I can install across multiple machines.