Exactly. They are probably the cheapest weapon to have. All those secret trips on the space shuttle were there for a reason. That's what happened to the NORK nuclear program.
The norms blew up the inside of a mountain multiple times until it collapsed. No rods from god. But go on and believe what makes you happy.
Norks, not norms
A plain tungsten rod the size of a telephone with no maneuvering thrusters or engine would weigh almost 25000 by itself
Motors/engine would absolutely be required as that much mass would be impossible to accurately aim without an expoentially heavier launch vehicle
The cost of getting that into stable orbit without it being obviously visible and still operation would be beyond reason