As far as smokes for a newbie, you'll want to stay mild for a while. But since you're already used to tobacco from being a pipe smoker (I smoke a pipe occassionally, too), you'll be able to move up in the full-bodied world faster than someone who's never smoked before.
Macanudo is a good, mild cigar. Some others I'd recommend would be...
Romeo y Julieta - Medium-mild, but has a great, consistent flavor
Baccarat - Newbies seem to love these, they have a sweet, mild taste
CAO Gold - Some find them bland, but they're good for a newbie because they're mild but will help introduce you to fuller-tasting cigars
Nat Sherman Host Selection - Also has a sweet taste, and is nice and mild. Construction is top-notch, and they usually go for cheap too
Romeo y Julieta Vintage - Milder than the regular RyJ, and has an almost fruit-like sweetness and creaminess
Montecristo - one of my all-time favorites (get the regular line though, you might not be ready for the Serie V or Platinum yet), with a medium-mild, almost coffee-like taste
La Aurora - another good mild one that's nice and smooth
Ashton - expensive, but very good ;-)
Don Diego - a lot like Montecristo, but not as flavorful
These are just some suggestions...but don't be afraid to try new smokes. You may find you're able to handle full-bodied cigars early on. Also, if you don't like something the first time, don't hesitate to try it again later. You'll find that your tastes change a lot.