Not much experience here, but I believe that higher level PR do pay off. Depending on the league of course. For higher leagues, I think advanced is always going to be profitable. For lower leagues, maybe competent or basic.
I think the main problem is, that people are penny pinchers, and are afraid to invest, if the investments revenues are not transparent. Advanced pr costs about 12+ per week, I think it will easily pay off in attendance and merch.
For lower levels, a competent one. He costs 7+, while the atrocious costs 2k. 5k isn't much really, it should pay off this way or another.