I think they now might have some kind of unleaded Cam2 but if they don't, you better think about your O2 sensor even if your cats are gone.
About the value of high octane fuel, it will only help you if your knock sensor is backing off on your spark advance because the 94 pump gas is causing knock under heavy load. With a stock engine, I don't think that will happen.
If you had increased compression, say 11:1 or 12:1, then you could gain by running high octane gas. The more you compress the charge, the more power you get. Of course, in the case of those high numbers, you would be required to run the high octane gas.
If you put Cam2 in a car that doesn't need it, you get no gain.