Unfortunately, "bullshit project" and "highly visible project" are not mutually exclusive opposites.
Some of my biggest bullshit projects have been projects that had several prominent eyes watching them closely, demanding frequent status updates and demos (the subject of which was not always articulated).
Nothing worse than working on a project that you feel is doomed to fail or at least fail to meet overly lofty expectations, yet still feel entirely responsible to try to pull something, anything off.
Also, never doubt the ability of managers and even less skilled developer-leaders to concoct improperly defined software projects to solve poorly defined problems.
I've seen, multiple times, management say "I have problem {X}, and I think a project doing {Thing A} will solve it", only for the same management to have "problem drift" such that "problem {X}" morphs into loosely-related "problem {Y}", which "{Thing A}" won't actually solve, but too late -- management is now convinced that problems {X} and {Y} are virtually the same thing, and {Thing A} which was poorly conceived to begin with, can now definitely solve {X} AND {Y} if only you'd read their minds and connect whatever vague dots they have floating in their heads for them and built the proper {Thing} for it".
Wow... this comment turned out to be a rant.
tldr; I somewhat relate to this article.