The hopeful expectation is that you don't go and solo things and find people to go with and they can maybe make up for your weakness in traps and lock-picking. However, if you cannot do that or play at a time where there is not as many people around, then yes, it is worth it to at least put one or two points in. It's a one-point wonder here with a caveat: you will need to know the items to help and where to get them, so initially the one point won't help, but as you gather items to help you boost the skill, it will be easier.
Unfortunately, because NWN hardcodes lockpicking/trap disabling at certain ranks so that only rogues can do it, that is realistically the only limitation at really high level locks/traps.
Unfortunately, because NWN hardcodes lockpicking/trap disabling at certain ranks so that only rogues can do it, that is realistically the only limitation at really high level locks/traps.