Most of my work was academic, but you can see what people are doing on /r/rpi (think that's the subreddit). People do crazy shit. If you're good at programming C or Python you can do virtually anything the hardware can handle by wiring other chips to the gpios.