In short, a high competition opportunity score is better. You have more chance of success within a niche with a high competition opportunity score.
Alternatively, if the competition opportunity score is low it indicates greater barriers to entry and well optimised competitor listings.