Although most PAL DVD players will play NTSC video -- you are correct that virtually no US NTSC DVD players can play PAL video. And that's true whether you burn a DVD file or an MPEG to a disc. It's a different aspect ratio, resolution and frame rate.
But you can use Share/Computer/AVI with the NTSC DV preset to output an NTSC DV file of your project. Then you can start up an NTSC DV project, load that file into it and burn an NTSC DVD from that.
It won't be perfect. But the program does to a pretty good job of interpretting your video from one format to another.