Frame weight is significant, but component weight will make a bigger difference.

That said, the ride qualities of different frames varies considerably. Good, light steel feels different than cheap, heavy steel, and is light years from "feel every bump in the road" aluminum. Generally speaking, a light steel frame feels much nicer than anything else (being an average weight rider who rides on decent roads).