I did it last year and will probably do it again. Organization was superb. Weather, last year, was cold and foggy (which is pretty good for a marathon if you ask me). Sometimes I've heard that there can be a headwind, though. You can check out the course profile yourself but it's downhill with the first half having more downhill, and uphills, than the second half.

i've done the relay 3 years in a row, and have run all portions of the 26.2 miles. The course is slightly rolling almost the entire way. The shirts and medals are nice. It's well organized and has a good amount of spectator support, which is good to have on your first. It's large, also good to have for your first. It's not very scenic, but as far as cities go, not bad, really. The first half is kinda rural/urban before it gets into the standard city-street atmosphere. Towards the end of the run there are a few live bands. Like Ken said, it's well organized and the weather is usually great. Good aid stations along the way. One of hte better marathons in the country, I think, and it should be a great experience!