DPKG (Debian Package Manager) vs XBPS (X Binary Package System)

DKPG has one of the best multiarch support you can easily add new architectures with dpkg --add-architecture $ARCH to install foreign architectures.

DPKG and it frontends follow strictly the UNIX philosophy that one package should do one thing well.

eg:

Dpkg: does simple package management
APT and aptitude : adds repository and dependency tracking
debconf: does configuration
synaptic: allows mouse interaction to all apt/aptitude options

Due the popularity of Ubuntu, Debian and Linux Mint it is almost certain that you find the package you want as a pre-built deb package.

DPKG isn't as bloated as other package managers since it is only made for local package management.

You can use apt, aptitude, cupt, debdelta or apt-build on the terminal.

There are plenty of helpers to easily create packages.
You just need to create 5 files: source/format, compat, rules, control & changelog and run dpkg-buildpackage.

It is possible to interact/ask questions to all pre and post install scripts. This makes it possibe to add questions for package configuration or to display EULA/License screens that have to be accepted before installation.

Deb packages are simple ar archives with additional tar, lzma, bzip, gzip support.

This makes maintenance and support easy.

XBPS can detect incompatible shared libraries or dependencies and gives you options before installing.

When installing software you can choose to install binaries or build it from source (natively or cross-compiled).

XBPS can not only be used for installing/removing packages, but it can query for package info (such as version, dependencies, size etc), reconfigure packages, report and fix issues by modifying the package database, search for alternatives, manage local repositories and various other useful tools.