A site I was consulting was getting a depressingly low number of email subscribers, so we tested one of these modal popups that prompted the visitor to subscribe... It worked wonderfully. To minimize the annoyance we set it to pop up only once for each visitor (based on cookies).
It wouldn't be so popular if it wasn't effective.