I only really had one worrying moment (not that I have a huge amount of flying under my belt) and that was when I was doing my PPL. After a solo flight, I veered off the runway as soon as I touched down and I didn’t know why. Quite rightly they had me straight back up with an instructor but I couldn’t do the landing and had to give back control. I didn’t like it at all. Definitely scared.
However, next day I was more than happy to fly and had no problem with the landing. I was lucky I guess as unlike some on here, I didn’t have a career to worry about, which must have compounded their problems.