I personally use 150gr soft-points. Brand isn't all that important, as long as you can put the bullet where it needs to go. I've just started handloading so I might try out a few of my own loads, but before that I took quite a few (I'd say 10 or so) deer with my .30-06's. Most fell in their tracks (those that didn't ran less than 20 yards), and all were shot with whatever cheapo 150gr SP Wal-mart had (usually Winchester. like $11 per box of 20). Heck my best groups in my '06 (a Savage 110) have come from the cheap 150gr Sellier & Bellot SPCE bullets.
I've just personally never understood all the debate about terminal performance. Sure some bullets will group better, but when it comes to shooting a deer, dead is dead. Don't do anything crazy like use a 90gr varmint bullet on deer, but IMHO some of the arguments are splitting hairs. Heck my father (without knowing state regs forbid it) was scrounging for ammo to go hunting one day and grabbed up a box of my American Eagle (Federal) .30-06 150gr FMJ target/practice ammo and went out with it. He shot a fairly large doe, and even with the FMJ, she dropped where she stood. I informed him about the regs after I found out what bullet he was using, but was still surprised at the results it produced.