"How often do people doing startups get scared or strongly discouraged."

There are ups an downs. It's easy to get discouraged - and sometimes, you should be. The success ratio for startups is not very high. But the startup environment has a lot of perks, like working on interesting problems with highly enthusiastic people. Teams help, as does remembering to actually get out of the lab occasionally.