It all depends. Sometimes it looks ok, but generally it looks amateurish.
On the subject of NO camera shake, though, i watch Pulp Fiction again last night, and there's a bit fairly near the end, when Butch Coolidge is going back to get his dad's watch...
He parks the car, and walks through some wasteland to get to his old apartment. He climbs through a fairly small hole in the fence, and the camera follows him through, and it's SO smooth. Go watch it.
Same as the Tarantino section of 4 Rooms. There's a CRAZY long section of that that's one shot. PF is full of long shots too, but 4 Rooms has the best one. It's all shot in one room, and people are moving to and fro, and it's just so seamless. Amazing.
But yeah, if the camera shake "fits" then go for it.
AMD Athlon 1700 (@2200mhz from 1466 sod the noise!) - 768mb pc3200 - 200GB Maxtor - Pioneer 106 - GF4 Ti4200 - twinhan/visionplus pci dvb-t - random pci analogue tv tuner - A7v600-x (to replace the a7n8x-d that died...) - random 17\" CRT
Sony STR-DE425 & Eltax c205s;
xBox w/20GB HDD- executer 2.3b;
xBox - standard;
Konica/Minolta dimage z10 w/2x512mb SD;
A silly amount of Cat-5 and usb cables