When I was in college, a friend did a real simple scene with something called a RHINO CAM. i never actually saw it, but it basically emulated the Requiem for a Dream/Pi shots you're talking about.
My friend's shots were kinda cool looking, but also awkward because he used them just for the sake of using them. the shots totally didn't fit with his scene project.
don't know if that helps....