How does armor affect stealth?
Does the type of armor matter? I know that Power Armor has a negative impact on stealth but I haven't really found anything substantial about other armors. Will I be detected more often when wearing metal armor than leather?
Your ability to sneak is directly effected by the weight of the armor you're wearing.
In most cases, it would be better to have lighter armor equipped.
If you have at least rank 4 in the Science! perk, you can modify your power armor chest with a stealth boy. This greatly increases the stealth capabilities, and would likely outweigh the stealth benefits of wearing lighter armor.