The RPM that the engine is going to make is fixed. What the sprocket or gearing change does is it lets the engine get into it's horsepower range sooner as you ride.
If you do not care about going 50mph but want better performance on the hills of San Francisco, then go to a smaller engine sprocket.