With this type of input device you can create effects that push or pull on your hand or resist movement. A full force feedback mouse works well with every effect type.
Not all devices of the same type feel the same. For instance, Logitech's Force Feedback sticks, specifically the Wingman Force 3D and Wingman Strike Force 3D, are significantly different than the old Wingman Force.
In general, effects such as springs, slow periodics, and vector forces are very compelling on these types of devices. High frequency periodics are often less compelling due to the size of the devices.
The Gravis Xterminator Force gamepad does a great job with high frequency periodics and springs. Vector forces, however, can easily get lost.