Not really, if I come up with a novel algorithm or a different architecture to do a task better at Google then they will give me the chance to implement it even if it takes months or years. Small companies doesn't care about your ideas, they just want a cog that can give them a basic website because that is all they need, novel things doesn't help them.
If you mean "novel product ideas" then sure, but we aren't product managers we are programmers so our ideas would mostly be related to architecture or algorithms.
Yes, just not challenges that requires ideas to solve. They are mostly just following the same path every other tech company went, re implementing the same systems. To them it doesn't matter if the system is better or worse, they just want a system since going from 0 to 1 is huge, meaning that they wont give you time or resources to implement your idea, they just want a cheap idea.
This is a very strange point-of-view.
I've worked in "small" (~100 employees or fewer) business my entire career, and not once was it strictly CRUD stuff in C#.
The freedom is debatable, I guess, since I have no experience at larger companies, but I certainly never found that my freedom is confined. Most often there is opportunity to contribute anywhere and everywhere, and management is happy to have the help.
Similarly, most of the devs I've worked with that are obsessed with "exciting" work still turn out pretty questionable stuff, and their careers would probably be better served if the built out a "simple" CRUD app, took it really seriously, and then examined the effects of their design on other teams.
