How tight should spokes be? Does it depend on the spoke pattern?
Spokes should be tight enough, as Chris said, that they don't go slack. That will depend on the rim and the load.
Worst case, with a lightweight box rim, the entire wheel load may be taken by the bottom spoke. Say it's a loaded bike with a heavy rider, 300 pounds total bike load, and 2/3 of that is on the rear, so 200 pounds is "standing" on that spoke. If the spoke was tensioned to 190 pounds, it's now slack, and at least one of the spokes is likely to fail within the next few hundred to thousand miles. If all spokes are tensioned to 100 kgf (kilograms force), or 220 pounds, they all stay tight, you don't have fatigue failure, and the wheel lasts a very long time.
If you have a deep section rim and a light rider, the rim doesn't flex nearly as much. If the rim distributes the load over four spokes, and it's ridden with a 150 pound bike-rider-power meter load, then each spoke only needs to be tensioned to 25 pounds. (Of course, the drive side tension on the rear wheel will likely be higher.) The manufacturer will be tempted to reduce the spoke count, e.g. from 36 to 24 spokes, and the wheel will still be solid with the load distributed over three spokes. (Until I get on that bike!)
All that said, I usually shoot for 105-120 kgf tension on 36 spoke wheels, and try to make sure the rims I buy will handle that much tension.