I also like Ajax's idea for the devine crowbars, but I wonder if the smaller projectiles would lose too much mass on the descent through the atmosphere to be as effective as he thinks.
The problem is twofold. First, you're going to lose mass due to friction from reentry. That's unavoidable, but something you can plan for. The real problem is accuracy. When you're dropping something from orbit, a variance of 0.001% is still missing the target point by over 2 miles! (Geosynchronous orbit is 22236 miles or so up.) This isn't a problem with Loki (where you say fuck this neighborhood and everyone in it) or his big brother Thor (where you say fuck this entire zip code and everyone around it), but for most situations it is... suboptimal. Which is why you only see the rods from god dropped on static targets, for the most part, because otherwise you have to rely on being close enough to get them in the AoE.
Going with orbital weapons used tactically, I'd say that, rather than the rods from god, you'd do better with orbital lasers or the like. You lose some energy to attenuation, but it causes far less collateral damage than kinetics. You could also do what is essentially a heat ray, hyperfocusing sunlight using orbital collectors to, essentially do the 'kid with a magnifying glass' trick. Because it is a DoT effect rather than instant, it would be a lot less problematic if you needed to adjust the coordinates. Plus, the fires it would cause would be secondary methods of corralling an enemy into a kill zone.