Refactor MSI Packager To a More Maintainable Way

[hollowaykeanho]

Description

This includes:

1. ~~Closing this issue: https://github.com/wixtoolset/issues/issues/7896~~
2. detect both binary and library built artifact instead of relying on placeholder files.
3. Ensures the new enhancement are applied.

Expected Behavior

MSI packager works as usual, the github issue is closed so that the upstream folks can have peace in mind and move on.

Current Behavior

MSI packager is wey too complicated and the upstream github issue is holding things up. Upstream team is annoyed with the slow timeline already.

Associated Data Files

No response