Does the iSight work with a different Mac? That would be the next logical troubleshooting step after confirming the USB is plugged in.
If it doesn't work with a different Mac, then you likely have a faulty display. If it DOES work with a different Mac, things get complicated.