Do I need an airbrush to get good results?

No, but it helps. Specialist community threads repeatedly note that hand-brushing and rattle cans can produce respectable results on armor and figures, while smooth aircraft and car finishes are much harder without an airbrush. Most modelers in the threads we read started with brushes and graduated to an airbrush once they were committed to the hobby.