These things don't just sneak up on you, at least not if you are planning and scoping your work ahead of time. If your workplace culture doesn't compel you to do that, you should do it anyway, so you don't get into situations like the one you're in.
That's the thing about being an employee at a company: the director says "look into FooBarTech", and so you look into FooBarTech. Ultimately, I agreed that the reasoning behind the investigation - all of the investigations - was sound. Our stack is big enough that any serious attempt to swap out low level technologies is going to take a decent amount of time, and the number of people who understand the whole system to the point where they can even attempt such swaps is small.
So, no, it didn't sneak up - but it still needed to be done, and I was one of three people who could do them without doubling or tripling the required time. Each time I accurately predicted the output, but executives looking to open up new multi-million dollar sales opportunities or to increase their bargaining positions with Cloud Provider X can't rely on predictions.
That said, none of this ameliorates the fact that I effectively have 6 "unproductive" months on my record; that I'm bored to tears of doing work just to throw it away.
A detailed investigation can easily take a month and then you just make summary of why you rejected it - brevity is often advantage.