I'd say that once you understand practical harmony, counterpoint, diminutions, common schemata, some basic elements of form, you've pretty much understood what classical music theory has to say about melody too. There's definitely an element of playing with expectations in a fully "creative" and rule-free way, but knowing the theory underneath is how you understand what the expectations are.