I find them usefull but not as much as they were with Classic ASP.
Now I'm using them more locally with triggers in packages that pump to and from remote servers.