This viz uses data going back almost thirty years. It seems that there’s a small, positive relationship between bigger salaries and winning more games. But it’s tiny. Most are clumped around the cap and if you’re there then you’re probably fine.
Best viewed on a large screen. An even larger version can be found on github.