As far as straight up heavy metal goes, Black Sabbath's Paranoid is one of the very best. It's very sincere and reliably silly.
A sumptuously produced blend of folk, post-rock, and psychedelia, all with a smokey stoner sheen. When it gets rolling the grooves are irresistible.