I've only been in low stakes sales roles (outside of personal projects) so this comes from someone with very little "professional" sales experience:

The good: setting a target comp that is realistic and explained (e.g. "I expect you to hit $200K 4/5 times with this plan.")

The bad: plans with complicated rules (x% up to $Y in sales with a kicker + incentives for certain deal structures) can be demotivating and incentivize the wrong sales behaviors

The ugly: some high-intensity salespeople might thrive on the chaotic and unpredictable nature of comp structures. I don't love the idea of hijacking the "gambling/variable reward" centers of the brain to get what you want out of your people. Be fair and simple.