What type of experience to the management about a programmer is consider reasonable?

Having been a manager several times, including managing managers, I can answer this with some authority:

It depends.

It depends on the manager, and it depends on the situation.

Managers aren't all clones of the same blob of primordial ooze. They have different personalities, experiences, and expectations. Based on individual experience, one manager may value programming ability over domain knowledge. Another might value communication. Yet another might avoid creative programmers like the plague.

Different situations call for different types of programmers. The type of programmer needed for an exploratory effort to produce a new consumer device is going to be different from the type needed for an embedded realtime effort on a device that could potentially harm people if it were to malfunction. Some projects demand lots of creativity, some require none. Most require good communication.

There is no one answer to your question.

If you're looking for advice on what skills to develop, or where to focus yourself, I would suggest a skill that I've found missing in many programmers: learn to listen, and to ask clarifying questions. Far too many of the people I've work with have had an "itchy trigger finger" when it comes to cutting code. But if you don't listen and clarify, you risk solving the wrong problem.