Effects of phase competition and frustration in itinerant and local-moment magnetic materials