I use my iPad at weekly staff meetings to show my team my progress on the sites I build, which means I usually cue up several tabs. I also use it during production to test several different sites. When talking about some new feature we want to add, I'll use my iPad to sketch some wireframes and jot down notes in Pages. I also use it to prototype mockups for an app I'm designing and test development builds. I also bring it to meetings across campus to demo for our clients what we're working on. I photograph some of our events and sometimes I use the camera connection kit to live Tweet what's going on (especially for bigger press conferences). When we visit research centers out in the middle of nowhere, it's nice to pack a small pack with my iPad and 7D and dump as I shoot. Then we can post to our Instagram and Flickr while on the go (not a big fan of Instagram but we use it). When I go on vacation or in the evening I use Diet Coda to remote connect and fix if something with one of my sites blows up (very rare). Or if a client for my freelance company somehow ruined something on their site (like if they're screwing with stuff they shouldn't) I can fix it. I also use it to demo to those clients. In the evenings my wife and I browse the web a lot, I draw and paint, and we watch movies on Netflix and Hulu. Oh, and to stream NFL Sunday Ticket. I also play a lot of higher-end games. In college I used it all the time to record and take notes during lectures, as well as make lots of thumbnail sketches and mockups for designs. I also sometimes used it to build PDFs to show my design process.
What drives me crazy is when I'm doing research for a post (on here or elsewhere) and the freaking thing reloads when I come back. I'm now in the habit of copying my text before switching tabs, especially if it's a longer post, and I'll paste it into Notes. When I'm reading news I'll often look up different sources and use quite a few tabs. I also forget to close them.
More RAM would be nice as it would open up future apps to edit hi-res RAW photos and also have a big canvas for painting with more layers.