So im in the process of starting a new campaign and one of my characters wants to play an awakened housefly. I need some help with the stats.
any suggestions?
Nice one.
Can't really do it with RAW D&D. D&D has never handled scale all that well. 3rd does it better than earlier (and later) editions, but more than a size class or two from 'standard' it starts breaking down.
Here is a stab at it anyway, assuming a fly that also has increased in size by an order of magnitude in the process of becoming intelligent (size fine is actually a significant advantage in and of itself).
Awakened Enlarged Fly
Size Diminutive
STR -12*, DEX +6, CON -12*, INT +0, WIS +0, CHR +0
Move: climb 5', fly 20' (good)
Drawbacks: No hands (can't pick up or hold anything, no hand/ring/glove slots, automatically fails craft, disable device, forgery, open lock, sleight of hand, and use rope skill checks), Can't Swim (automatically fails swim checks), poor vision (-6 spot checks), squishy (dies at -6 h.p., massive damage threshhold 30 h.p.), disgusting (-5 penalty on all charisma related skill checks when interacting with non-vermin),
Benefits: Natural climb speed (+14 racial bonus), natural fly speed, natural Armor +1, all around vision (can't be flanked), low-light vision, scent, blind sight 5' radius, vermin traits, racial feat (lightning reflexes), agile (jump and climb are dexterity based skills)
Attacks: none
*Character must buy at least 12 base strength and con before modifiers.
And that isn't even really screwing the player over. You are perfectly within your rights to declare that a fly can cast no spells that require a somatic component.