Like I posted above, it varies with the plane. Trust me on this one, I've been a full scale flight instructor for years, and had to go through a lot of classes on aerodynamics. It all depends on flap design, wing design/location, cg location, and airspeed that you are carrying when you put the flaps out. In general, most planes do pitch nose up, but there are plenty that put the nose down.