I think necroing this thread is acceptable for this reason.
Inspired by Nordic sagas of Odin and berserkers (especially their immunity to weapons and hangover effect) and also Asterix&Obelix magic potion.
[CREATURE:HONEY_BEE]
<snip>
[USE_MATERIAL_TEMPLATE:MEAD:CREATURE_ALCOHOL_TEMPLATE]
[STATE_NAME_ADJ:ALL_SOLID:frozen mead]
[STATE_NAME_ADJ:LIQUID:mead]
[STATE_NAME_ADJ:GAS:boiling mead]
[PREFIX:NONE]
[SYNDROME]
[SYN_NAME:mead effect]
[SYN_INGESTED]
Potion effects for 11200 ticks (which is roughly time to become thristy. Dunno where I found that value)
[CE_MATERIAL_FORCE_MULTIPLIER:MAT_MULT:INORGANIC:NONE:1:5:START:0:END:11200] x5 defence against weapons
[CE_PHYS_ATT_CHANGE:STRENGTH:200:0:AGILITY:200:0:TOUGHNESS:200:0:START:0:END:11200] x2 strength, toughness and agility
[CE_SPEED_CHANGE:SPEED_PERC:150:START:0:END:11200] x1.5 speed
[CE_FLASH_TILE:TILE:24:3:7:1:FREQUENCY:200:100:START:0:END:11200] flashes light blue up arrow
Hangover effects for next 11200 ticks:
[CE_DIZZINESS:SEV:100:PROB:100:START:11200:END:22400] dizziness
[CE_FLASH_TILE:TILE:25:2:7:0:FREQUENCY:400:200:START:11200:END:22400] flashes green down arrow
<snip>
Still unsure about CE_MATERIAL_FORCE_MULTIPLIER:MAT_MULT:INORGANIC:NONE tag - it should work as resistance to anything made of INORGANIC:XXX material, but maybe I should put INORGANIC:IRON, INORGANIC:STEEL etc instead?