Bear in mind that OPC Scripts are meant to automate mundane tasks. It is unlikely that you will be able to perform challenging tasks using them. If you are a blacksmith...you may be able to use OPC Scripts to automate tasks that are mundane for you...something that is so simple for you to do that you have little chance of failure. Like making horseshoes. But if what you want to do is challenging? You're going to need to be online for that one.
OPC Scripts are not intended to replace actually playing the game. An OPC will be useful, but not nearly as useful as an actual player would be.
In essence, OPC Scripts are meant to automate things like training (which only improves your skill in something to a certain point), exercising, traveling from one place to another, running a store, walking a beat as a guard, and other simple, mundane tasks. It is not intended as something where you just program your character to do all the things....then never really have to log in again.
So, in theory...I suppose you could try to create an OPC village....but it's going to be a pretty lackluster village that is just barely getting by, at best.