In America, we tend to answer over-positively, so "great" might equal "good," good = ok, and ok/fine = not that good or neutral. "Not bad" is very common for a neutral expression, especially if said in an upbeat sort of way. It may depend on intonation and body language-- sometimes people can say 'fine' or 'ok,' and it actually implies they aren't doing great. If a person answers "fine" and they seem irritated or sad, sometimes they might expect you to ask "is everything fine." Sometimes we call that "fishing;" when a person answers "fine" or "ok" and they're trying to get you to ask them if everything is fine. Some of what you saw in movies is probably related to the above. Of course, it also varies by personality, energy level, gender, etc.