It would probably depend on how the resolution was being handled ...
If you set your XBox 360/PS3 to output at 480p, if the game's native resolution becomes 480p you should see a much more stable framerate; on the other hand if the native resolution remains the same and the XBox 360/PS3 scales the output image to fit your 480p display you will see no improvement.