Being recognized by management as contributing is more a social issue than anything else. I feel that you implicitly recognize this when you characterize work as "'cool' stuff that is seen as difficult" - the perception is more important than the work or productivity.
A modicum of time spent communicating what you have gotten done can pay dividends. A lesson I need to remember from time to time.
I guess you really never can tell what the other side is thinking. But at the same time, in hindsight this was predictable since it impacted a bunch of high-visibility reports and the manager probably got feedback from upstairs.
This has more to do with making their life easier and giving them bragging rights, than it does with anything else. If you can make your manager look good in front of their manager, then good things will happen to you.
There was one time that stands out where everybody expressed gratitude for my hard work and asked if they could help me out. It was when I spent a week running cables and setting up PCs for our incoming batch of interns.
I know that programming is much more challenging than crawling under desks and plugging things in, but none of them ever really saw the programming. All of that crawling, though--I looked like such a hard worker that week.