Well i have been a Avid Commodore User and Big supporter since the C-64 days, Recently i got a Amiga cd32 ( NTSC VERSION ) in Trade for some work i did. I have wanted one for a long time but always heard about NTSC System problems with most of the games, I have bunch of software and luckily some games work without a problem, I have multiple Lcd tvs and even a Panasonic AE2000U projector in my movie theater i can hook this upto but of course they are all NTSC. So the question is after much confusing research ( GOOGLE hehe ) is there a definitive aswer to get this to work with Pal software, I dont care about the money i just want to re-live my youth playing most of these games. Thanks in advance guys

Money aside, I would consider buying a PAL CD32 - you can use your US CD32 PSU with it - so look for a cheap PAL one without PSU.

Part 2 - converting PAL to NTSC -

This is actually quite simple - you can spend a few bucks getting a CRT/TFT tuner for about $50 - this will take a PAL signal and convert it to VGA - XVGA - this output you plumb into your LCD's / CRT VGA monitors

Your best bet is to get a PAL unit and either plug it into a PAL / NTSC converter or a PAL / VGA converter like Zetr0 mentioned. Obviously an NTSC CD32 will plug into an American TV with no problem as long as it is booted in NTSC. I went a step further and purchased a "multisystem TV" from an airman returning from Europe. Got it for $40 on craigslist.