This has included setting up the ten-year old heater in our garage, installing specific computer components, fixing various plumbing issues, realigning a PS2's DVD drive, and even repairing our vacuum cleaner when its drive toggle fell out. However, it goes beyond the realm of the useful. Stuck on a specific part of an obscure video game? There's a video of someone working through it. Want to see who would win in a fight between Batman and Darth Vader? There's a video on that too (and fairly well done, although I prefer the alternative ending). The construction of a Klingon battle cruiser? It's there. How to build a sword like Cloud's from Final Fantasy VII? Yep. The wide variety of what is available is staggering.
Now, there is some crazy stuff out there too. There are realms on the Internet, much like some parts of the world, where I hope that I never find myself. There are some aspects of humanity that I do not need to see.
Still, the vast amounts of creative ingenuity found on the Internet provides me with hope for humanity as well.