What you want to track Usually Why
One fact per record, like a contract end date on an Account A custom field on the standard object There's one value per account, so a new object only adds a join to every report.
Many of something per record, like the machines installed at each customer site A custom object with a relationship to Account Fields like Machine 1, Machine 2 and Machine 3 break the day a customer has a fourth.
The same object, handled differently by team, like service deals vs product deals Record types on the standard object Different page layouts and picklist values without splitting your pipeline reports in two.
Something that belongs to two parents at once, like a Contact who works with several Accounts A junction object with two master-detail fields It's how Salesforce models many-to-many. Check the standard options first: Contacts to multiple Accounts is built in once switched on.