For me it depends. The longer the lens is, the deeper and more useful a hood becomes. The wider the lens is, the shallower the hood has to be not to impinge on the frame, and at a certain point, it becomes relatively useless for shade. I use hoods on all my lenses that have them, but the petal hood on my 24-105 is only about an inch to an inch and a half deep and less protective and shades the front element far less than the four-inch solid hood on my 135, or the built-in hood on my 400.
But on my 8mm circular fisheye? No point. The lens comes with a >1cm deep collar so you can put a lens cap on it (the front element is convex). If I leave the collar on the lens, roughly a third of the frame is vignetted:
with collar:
without
So the fisheye is
always naked when I shoot.