Sorry I thought I read you got it installed already, if it doesnt even let you boot the dvd its fairly complicated to inject a modded kext into a distro (never done it myself), so it would be easier to find another distro that works with your controller.
But its strange that it doesnt even work when booting from USB DVD, that doesnt need any nforce ata support, what error do you get when booting from it?