it depends on the enemy. Too broad a question. In Iraq, it's a police situation, trying to maintain order and peace. In Afghanistan, they're trying to find a group of people that are in hiding, and being supported by some of the local tribes.
The future... Iran, similar to Iraq, but with better weapons and not afraid to use it. N. Korea... maybe they'll just negotiate against war. But, it's a treacherous region with lots of hills and a morally defeated populace. China, lot's of people in a large military, but technowise, they're still a bit behind us. Venezuela, should be pretty easy and the population will enjoy the removal of Hugo... as long as we don't overstay our welcome. Russia, the next great enemy... equally matched and since the fall of communism, they've acquired a great wealth in oil and have shown their regional dominance with the invasion of Georgia while we just sat by and watched. We're going back to a dual Superpower society... East v West... again... this time, they might win. They've learned from their mistakes while we've gotten soft, especially where it counts... in Washington.
Spec Ops... will always be needed. And will only get better in the future. Hopefully training standards don't decline and equipment gets better.