If you are unfit then strenuous physical activity tends to feel very unpleasant and stressful. As fitness improves what was hard feels less and less so
This is a very important point. I didn't do any sports until I was about 25. Nothing. Only the stuff they made us do at school, and I hated it with passion. You know that child who is always the last at every race, never picked for any teams? Me. Simply not sporty.
In my early 20s I tried some sports and like you, I literally could not run 30 seconds. Tried and tried but was just out of breath and in pain.
Then I tried classes and looked ridiculous. Even the most basic aerobics steps were way over my abilities, was totally unable to follow, bumping into everybody like an idiot.
But I did find something I quite liked that didn't require intensive cardio or complicated coreography. In my case this was Bodypump, but that doesnt' really matter, could have been anything. The point was that I didn't feel like I massively sucked at it, for a change. So I kept going. I got fitter. I started tentatively trying other things and as I didn't immediately get out of breath, I discovered I quite liked several other classes. And if I just jogged as slow as possible, this was quite enjoyable too.
I'm now a group fitness instructor and just signing up for another race (half-marathon this time). Close to 40, 2 small kids, fit and healthy. If you told me this 20 years ago, I would have laughed my head off.
tl;dr - if you can't find any sports you actually like, choose something that you don't hate too much. If you do something regularly, you will improve. When you get fitter, it and other sports will get more enjoyable.