It'll be dull if your team has more people than real work. It'll be dull if your team can't articulate what the problem it solves or why it matters. It'll be dull if you are solving a problem that has better solution somewhere else. It's not about company size, but about culture and project. It was not dull to build the first version of S3 or EC2 or DyanmoDB. It was not dull to come up with Chrome or JAX or TPU. It was not dull to drive the project of Vision Pro or iPhone or Apple Watch. It was not dull to build Github Copilot.
It's just that statistically speaking one has fewer chance per 1000 employee to work on something fun without being dragged by company culture in a huge company.