No, without adding anything else to the SPDT circuit, the limit switches need to be closed when the monitor is not in that position.
However,
According to the Solarbotics data sheet on the secret drive, as long as the enable input is tied to + VDC, both directions can be high or low to apply braking. So with the SPDT circuit, when the monitor reaches end of travel and the limit switch opens, both directions to the secret drive will be low. In my SPDT circuit, I have the drive's enable always tied to +vdc, so this circuit already does what i think you are wanting.
Here is a link to the data sheet:
http://www.hobbyengineering.com/specs/Solorbotics-kit10.pdfScroll down to page 9 and study the logic table.
With enable high, both inputs low or both inputs high produces braking.
Now about servos. A servo holds its position because it senses the position and constantly corrects for any drifting.
A DC motor does not do this. When current flows through the motor, it turns.
When current stops flowing, it coasts to a stop.
When power is removed, a DC motor will coast. However, while it is coasting it becomes a generator.
You can short the generator and it becomes harder to turn. But enough force can still turn it.
Unless you put a sophisticated tachometer or encoder on the dc motor and have a drive that can correct the motor for drift, you more or less just have to design your rig around the coasting of the motor.
Decreasing motor speed can cut way down on motor coast, but it also adds to overall time it takes for the monitor to rotate.
You can concentrate on the design of the flag (the thing that is attached to the disc and activates the switches).
A flag that is wide enough to still be activating the switch after the motor is done coasting is one way.
I think you need to design your rig so the monitor cant "back lash", or turn backwards slightly after stopping.
Motor braking may prevent this, provided that the monitor is not running really fast.
Hint:
My next MRotate version is going to have the option of adding an encoder like a mouse opto and wheel (could possible hack a mouse to get it.)
The encoder will count up or down a counter. You will be able to set slow down points along the counts which will allow the monitor to slow to a very smooth stop. Limit switches wont even be necessary to stop rotation, but rather be back ups in case something happens.
But, it will be fully automatic, controlled by the computer, which is something you are not looking for.
Hmmm, a DC brush motor acting like a stepper. I wonder if it will be as precise as the stepper?