The distance completely changes the dynamic. If I tell you there's a crazy axe murderer in your house, you should be afraid. If I tell you there's a crazy axe murderer on Venus, how afraid are you?
And unless we are completely wrong about physics, the maximum speed of a weapon will be the same as it today - very close to 1c.