When the Emperor Meijii assumed the throne of Japan, it was a largely ceremonial position.  Within a few years, he was emperor in fact as well as in name.

That's just the most obvious case of someone taking a "largely ceremonial" post and making it meaningful.