A few developers have already built their own maps into apps. OS 3.0, however, should make it a lot more common. Here's the definitive list of all apps that use fully interactive maps.
The biggest name GPS navigation company now has a north American iPhone app. the $70 price tag will likely go up after August 15. Make sure to take a look at the free version of the app which will give you an idea of what sort of functionality is available in the full version.
This is a more reasonably priced turn-by-turn app with voice guidance. It comes in several versions differentiated by geographic location. This one in particular is just California, but there's G-Map for the Western U.S. for $34.99 and a G-Map for the Eastern U.S at the same price. There's are also separate apps that cover other, smaller, areas.
Offered for free, AT&T bills you $9.99/month for this turn by turn application on your monthly statement. Deleting the app does not cancel service - you have to go online or call.
A free version of the North American version of Navigon MobileNavigator. It's meant for you to test out the functionality of this very expensive iPhone app for free. It still includes all the maps and is more than 1 GB in size.
This is one to keep an eye on should it get some great updates. It uses map information from www.openstreemap.org (the wikipedia of maps) and it's possible it could become as useful as wikipedia over time.
A fully-featured competitor for Apple's built-in Maps app. There's a one tap carousel of common locations one might search for, like hotels, gas stations or restaurants as well as the ability to specify multi-stop routes.
AroundMe has always been a decent alternative to the Maps app for finding places nearby, but it always lacked maps. Not anymore. Fully interactive Google maps are now built-in.