It sounds like you might have an issue with analysis paralysis. You hear about a great idea, get all fired up and dive into to the research, then run across people who have done poorly or had negative experiences and get gun-shy.
There are lots of people who have made a killing in real estate, and there are a lot of people who have been killed by real estate. But one good thing I like about real estate is that barring a market collapse or significant "correction", you can't be completely wiped out. You might buy a house for $100k thinking you can get $300k for it, and after cost-overruns on your rehab, some permitting delays and a sellers market, you only wind up selling it for $200k and no profits or some loss. At the end of the day you still own a lot and/or house and it will still have value. You might lose money on a deal, or your flip can go sideways on you, or rents might not be what you expected, but as long as you do your research and due diligence you won't be wiped out.
And in the name of everything holy, be careful about using leverage when you are new. It makes getting into a deal much easier, but also makes it easier to lose your shirt if things go sideways.