Vulnerabilities on the web can cause many different times of hacks. You can use it to get access to another users data. Or it can work as a step towards remote code execution.
A great way to see real examples of specific attack you can check hackerone.com like this through google: