Most are not at all harmful to people and all of them eat a ton of insects; I personally like to see spiders around (except Black Widows and Brown recluses which thankfully are fairly rare around here).

Now, if they would just eat the mosquitos...