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.
What's wrong? Where are you going? Stop! Read this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop