I didn't find it perplexing. The way you know whether JR's good at being an oilman, is to listen to how his peers and competitors talk about him. How much do they talk about him? A lot? How much they worry about him and how much they talk about him compared to how much he talks about them shows you where he ranks and where they rank on the food chain of the Texas oil industry.
Why did so many of JR's ventures go badly? I'm pretty sure they did it for the purpose of creating drama. It's exciting for the fans when Ewing Oil is often on the brink of being ruined. It's not how you'd handle a business in real life, but it's TV - it's gotta be more exciting than real life so they make it larger than life and manufacture one crisis after another. That's basically what the soap opera genre does, isn't it? If they portray JR as being a more sensible oilman who doesn't like to take unnecessary risks, he might appear even more successful, but then they don't end up with one crisis after another. It's done for entertainment value.
I was just watching an episode from season 7 and Bobby is talking to Clayton about the possibility of Clayton joining Bobby and JR in investing in an offshore oil lease. Bobby says: "No matter what you think about JR, and believe me, there are a lot of negatives, he is one of the best oilmen in Texas." Here is Bobby who has had huge differences of opinion with JR regarding business ethics, and as much as he dislikes some of the things about him, Bobby can't deny JR is one of the top oilmen in the state.
How many scenes are there where several people are talking about JR and what they are going to do about him? People who don't fear someone aren't gonna spend so much of their free time talking about "how are we going to stop him." Why would they spend so much of their free time talking about somebody they don't like and don't see as a threat? They feared JR's capability to do what he wants to do. That's why never shut up about him. Even Ray and Donna, who weren't even in the oil business, seemed to spend as much or more time talking about JR than they did talking about people or things they actually enjoyed talking about! It must have really tickled JR to know that they and his competitors, especially Cliff, spent so much of their time worrying about him and talking about him.
Cliff talked about JR incessantly. Even when he was trying to romance a woman, even when he was out on a date, Cliff talked about JR. That didn't exactly endear Cliff to his girlfriends, which is one of the reasons he could never keep a woman. He lost Mandy when he told her "I need you now more than ever" and then proceeded to tell her it was so he could use her to pretend to like JR and date him so that she could collect information about what he was doing. The funny thing is, by deliberately having Mandy have spend time with JR, Cliff engineered the whole scenario that ultimately resulted in his hated rival taking his woman from him.
In contrast, JR spent very little of his free time talking about people he didn't like, and worring abut how he was going to "stop" them. People did that regarding JR but JR didn't because you don't do that when you rank at the top of the food chain. While they were constantly worried and upset, JR was smiling and loving life. That's a big part of what made JR Ewing such a pop culture phenomenon. People liked JR despite his underhanded tactics because it's hard to not like somebody who is always smiling and is so good at what they do. People love a winner. When you're the one who is making everyone talk about you, that pretty well establishes who is on top, and who are the people who aren't on top but wished they could be.