Never wanted to do anything like this myself but I have found Nero to be quite straightforward for most standard things.
BUT, it sounds like you're not looking for standard. If you want a DVD that is playable in a plain vanilla 'fits under the TV' DVD then it has to be recorded in a specific format - this may not be compatible with what you have in mind as a seperate folder on the front page for the photos and the videos. There are formats that facilitate both DVD players and computer readable data but I don't know whether Nero supports any of these.