Originally Posted by
Shrankar
If you have a group of players willing to play with you, Enhance is a fun spec and can be decent in all content. That being said, community perception will make it a lot harder for you to find groups or a raiding guild. The big problem for raiding is that it takes up a valuable melee spot and offers nothing that an Ele or Resto Shaman don't also bring to the raid. If you are willing to play multiple specs, you shouldn't have a problem.
Holy Paladin will probably be the easiest to find groups if you are happy being a healer. Mages are often taken as fire for PvE more than frost, but are wanted for all aspects of the game. Warlocks are highly wanted for both raiding and PvP (ours often switch between affliction and destro though), but I hear they have a little more trouble getting a spot in M+.