I suspect it is pointless to ask people here about the usefulness for you - this depends where you live etc.
I suggest you to take a look at job advertisements in the area you live and look for things like "web services" and "system integration" etc.
Personally, I feel that although some of the technology covered by the SCDJWS certification is not very "hot", the mindset encouraged by a service-oriented thinking is beneficial, despite the technology you use in the end. I have not experienced any drawbacks after having gained the knowledge and having passed the certification.
Something about .... going for a swim. With this tiny ad ...
Devious Experiments for a Truly Passive Greenhouse!