I've seen some wonderful Rotties before, as well as heard of local incidents and dogs that were not-wonderful. It's true some dogs can be.. well, funny, but as stated before what they'll grow up to become depends on what you mould them to be. If you raise them with love and care, but also discipline and guidance, then of course they'll be good pets.
I remember this Alsatian from about two years back that met my own mongrel Mel a few times when we met her owners more than once in the park. She was a gorgeous animal. We almost got a German Shepherd, but the only error with him was that he was too big for our house. xD Great manners (dogwise), and a great temperament.
But, well... there are lots of gentle-natured animals that can become surprisingly good guards. >3> My Labrador wouldn't - couldn't, she's so soppy - kill anything but she's a fantastic guardian. She wouldn't hurt a fly but I'd trust her with my life anytime, given the idea I'll end up threatened by something. And by goodness, is she strong. Unbelieveably tough. She's the ideal dog, I adore her~ So, who knows what might catch your eye?