yeah, ok i just did a google search.
the 'spoon' pipe is the variety i used for years.
i had the same issue with bongs/smoking through water as you. caused all kinds of horrible coughs and such.
i probably got my first glass pipe in 2004 i reckon, something like that...and every time i've broken one, i've replaced it because they're so nice to smoke through. they used to be hard to find in australian head shops, in my area anyway.
now, i can't tell you much about the steamroller - i think i used a bamboo equivalent once, and it wasn't the best, but probably no comparison to glass. i would be wary of the end heating up though (too much to put your hand over the end) and i can't help but think you'd end up with a resin-covered hand.
the spoon pipes, on the other hand, fit nicely into your palm and they're just a nice classy way to puff on a bit of weed.
i would certainly advise using a screen, as i once broke a pipe by constantly stoking the hole, and eventually the heat weakened it, so when i pushed the ash/resin that was blocking it through, the glass cracked.
i still have a nice spoon pipe and though i don't use it as much as the vape, it's nice for a change. i suppose smoking feels a bit weird to me now, but those pipes were my standby for years.
they're very smooth, and everyone i've ever loaded one for has said "wow! that's nice!"
it was my choice of smoking vessel for years, for my heaviest smoking years.
i wouldn't worry about tolerance issues with either of these pipes - probably only bucket bongs would cause any issues with that, i reckon, and even then, joints are something else altogether i reckon - all that repeat toking gets me really high.