I've been smoking a pipe since my college days, some 35 years ago. I have never smoked cigarettes and rarely cigars. And I can't say that I smoke a pipe that often during the year, mostly in the fall and winter a couple of times a week, sometimes even in summer if flycasting or sitting in a pleasant spot overlooking water while enjoying a rich single malt. I have a good number of vintage Dunhills, Sasieni family era pipes, Charatan, and Ben Wades among others. And a few corn cobs. Never underestimate the value of a good corncob, especially with a lot of straight Virginias or blends that can burn hot and bite in a briar (especially a poorly cured cheap briar) until you become more experienced with them.
If you want personal reviews and the straight skinny on pipe tobacco blends try this site:
TobaccoReviews.com - The largest collection of pipe tobacco reviews on the internet
Since you are coming from cigarettes, do you want something similar in flavor and character, but richer and far better quality tobacco? Maybe a light Virginia, Turkish and Burley character? Then a mild English blend may work for you. Rattray's 7 Reserve is a good example, a mild all day tobacco with only a small amount of latakia. Also good is MacBaren's Virginia Blend or their Virginia #1, all straight Virginia. The former is especially good for new pipe smokers. Also good is Samuel Gawith's Squadron Leader another milder blend with a pleasant room note, or Golden Glow a very mild and pleasant Virginia.
I recommend that at least you start with a good quality tinned blend before trying different store brands and popular low priced pouch tobaccos, at least until you become more experienced at smoking a pipe, to avoid unpleasant initial experiences. If you have a local pipe shop where you can sample some of their store brands and get decent advice from an experienced tobacconist, they are a good resource.
Since I like primarily English blends and occasionally some cased Cavendishes, if its something like a fruity flavored aromatic you are after I can't really help ya there!
