I'm trying to remember a time in any isometric rpg where I got really excited about a piece of gear and the only moments that come to mind are when I found unusual items, not powerful ones. For instance, in Baldur's Gate you can find a cursed belt that causes your character to semi-permanently change sex. Even back in the day when I was first introduced to the genre I can't say I ever really got excited to find the next +X Longsword of hits harder. Maybe I'm alone here.
Definitely want interesting loot with RP value. Items that change one of your tags, for example, could be pretty significant.
The main problem with the loot RNG in this game is, it is to random. There are many disappointing moments: You find a rare or even epic sword for your warrior and then you realize it adds +3 to intelligence. Or a dagger that gives +3 to strength.
Either you must make the stats more complex, so that even a finesse fighter gains a benefit of strength, or some items shouldn't be able to gain specific 'benefits' if they make no sense at all on that item.
In a game with limited loot total RNG is totally a mood kill.
All those moment:
Just found: Yay, epic weapon for me.
Identified: Nay, those stats totally suck, such a garbage.
As Stabbey said, intelligence on weapons can be nice for hybrids, though the strength on a finesse weapon won't typically be useful. Maybe for some weird rogue-warrior build, but that shouldn't be that common. So getting rid of nearly completely useless modifiers on certain items would be good.
Some kind of Enchantment system where you could change a modifier could help deal with this problem. Something like you combine two items, and pick one modifier from each to swap them, or you destroy one item and bring one modifier from the destroyed item to the other item, replacing a modifier you dislike. Obviously this would be some work to implement, but I think it would do a lot to alleviate some of this kind of frustration while still leaving value to random loot and not making it easy to make the exact items you want.
Another partial solution would be to increase drop chances of weapon types your party is actually invested in (via weapon skills). Nothing like finding an amazing two-hander in a party with no two-handers. Maybe certain boss types or chests guarantee a party-appropriate item, kind of like in Diablo 3, for all its flaws, where bosses always dropped items equippable by you on first kill.
