I'd argue that the mod developer is not doing anything unethical. They're providing optional content, usually custom art assets. If they're visual mods (such as sails for a ship), they should not be affected by updates to the game (unless scripts are also involved).

You do bring up an interesting question of how long to expect support for a paid mod after its release; that issue is going to be between you and the modder.