For years now I would only buy the San Marzano brand crushed tomatoes (the one in the white label, with the red tomato printed on it), however they can be a bit pricey at $4+ per can in my area.
I've never really been a fan of the more common name brands like Contadina, Red Pack, and others (though I would sometimes use Hunt's when in a jam). They all tasted too bland to me, and lacked the tartness and sweetness of the San Marzano ones.
Recently, I tried out another brand called "Diane's Garden" from a local discount grocery store called Save-A-Lot. I was really surprised at how good they were, and to make things even better they are only 99 cents per 28oz can.
Apparently this is their store brand, so I'm not sure if these are available anywhere else, or who actually manufactures them. But I've been using these exclusively the past several weeks, and saving a lot of $$$ at the same time.