Tripods are only hugely helpful for long exposure pictures such as night time or indoors shots without flash. They're also necessities for bracketing for HDR or time lapse. If you've got a ton of light, you can use shorter shutter speeds that help remove your hand movement from the equation.
I really like using a tripod for sunset/sunrise photos. You only have a short period of time when the light is truly spectacular. So I like to set up the composition with the tripod and only have to worry about exposure once the sun starts reaching the horizon.
Then you've got your indoor shots and your shots where you want to get into the picture using a timed shutter that also need a tripod.
Then again, everyone's got their own threshold for blurry photos so if you don't think you need one, or if you never use your camera in the above scenarios, then more power to you. This thread wasn't about whether or not to use a tripod - it was about whether any inexpensive tripods are any good.
They're also helpful just as a simple stand or holding device for your camera. If you're doing studio shoots or, say, groups of people at a wedding, it's handy to be able to leave your camera safely in one place while you move around and talk to people and do stuff with your hands other than have to carry a camera, or have it dragging on your neck.
Once you get everything taken care of, you just step back behind the tripod, verify your framing and focus, and snap the shutter. (If you are taking a lot of shots of the same general subject/environment/lighting/location then you can lock your focus and exposure and never change them as long as you don't move your tripod. Just be sure to compensate if something does change; a cloud blocking the sun can cause a stop or more of difference.)
If you have a remote shutter release, you don't even have to be behind the camera, which is handy if you need to hold something to block/reflect the light, or entertain a baby to get it to look a particular direction, or anything else that requires an extra set of hands away from the camera.