Its not just for *rallying cars'. You have much more control. Its not hard, and it doesnt get boring (sometimes it can get a little irritating in packed traffic but I think an automatic would annoy me even more in those situations). You just change gears, thats all.
Its also a matter of preference though.