Well, actually this was just done as a test of the Flickr link to blogger, but it is a moderately amusing photo anyway. I've been playing a lot with a Panasonic G1, a mirrorless dSLR which makes most normal dSLRs look bulky and needless, but I have to say when you want to mess about like this, you can't beat my huge, heavy D3 Nikon.
However you don't actually need a battleship dSLR to do dog shots. I like this one of Delphi when she was young. My first ever shot with an Ultra Wide Angle lens, which is pretty much my signature style now.
Dogs make interesting models I think, but then I like dogs. You can do this kind of shot, Delphi looking noble, easily with any camera.
On the other hand, while I have no doubt someone HAS done this on a camera phone, the D3 and 70-200VR makes it a lot easier.
It is the photographer, not the camera, that makes the picture. But the right kit for the job helps no end.