What is a word that is amazingly cool in your imagination, but in reality, it's not THAT cool?

I remember when my cousin told me he was cooking the holiday bird with a turkey cannon one year. I was SO excited. I had no idea what a turkey cannon was, but it had to be cool with a name like that.

I knew it most likely wouldn’t launch turkeys through the air, but it had to have the name “cannon” for a good reason, right? Perhaps when it was done cooking, it made a loud exploding noise. Perhaps at least, you got to stuff the turkey into the device as if you were loading a cannon.

In actuality, it’s pretty handy, but nowhere near as cool as the name is. Its just this thing that you fill up with liquid and stick in the turkey cavity to make it more moist and cook faster. Handy. I want one—but nowhere NEAR as cool as the name “turkey cannon” might lead you to believe.

Do you have any words like that?