It's really very context dependant. Aero road bikes are generally heavier than regular ones, and faster except uphill. Lighter bikes are easier to move around under you. A lighter bike is easier to pick up and carry. Depending on your body composition a heavy bike isn't bad for your health.