You'll find they're probably not the best tools for a lot of the 'infinite ways' you expect. But they're great for simple data entry and basic calculations.

The novel ways I've seen them used are around the development of Apps / internal tools, using low code builders like Budibase