big difference bro....
on auto, its just smooth...on the manual u get the kick back feeling, its instant clutch power, where as with all auto's its just waiting for the torque convertor to transfer the power, therefore smoothness is all u get....ofcos if u mod ur car, sure it wont be much diff...probably a blown auto box in the end :P