I sure have. Lots of JRPGs, like Dragon Quest VII, for example. Games like that will often be light on gameplay the first couple hours, as they use that time for world building and mood setting. That would make for a terrible demo.
There are games that you start off limited, but pays off as you unlock abilities.
Then there are games that just start off poorly, but end up being better later on like Wolfenstein.