Legend of Dragoon is close to the top of my list of games I'd love to see remade, but almost certainly won't.

Actually, FF8 is at the top of that list. It's my favorite of the "mainline" FFs and the story has aged by far the best out of the series, but the systems, equipment, and stat working is awful. Like you're running into, the systems are confusing and difficult to figure out, but as soon as you "get it" you almost have to handicap yourself so as not to completely break the game. A remake along the lines of the FF7 rework could fix that, and I think 8 would benefit from the treatment more than any other game in the series.