Speaking as someone who's worn a kilt as part of my dress uniform for almost all of my military career, I have no qualms saying to the original poster that you should look at joining the Camerons BECAUSE they wear the kilt. It's a fine piece of military dressed, steeped in the undeniably proud military heritage of the Scots. Someone suggested that kilted Regiments tend to wear the kilt about 3 times per year; actually, it's generally more than that--Remembrance Day, Robbie Burns Day, Regimental Birthday, Soldier's Christmas Dinner, other Regimental Days, military funerals, Freedom of the City parades, and similar events can all add up to wearing the kilt almost monthly in some years. Granted, there is a tendency to do more of this sort of thing in CADPAT in recent years (such as Freedom of the City), and I'm sure some units spend more time in the kilt than others, but a member of a Scottish (or Irish, for our Sudbury, Ontario brethren) should expect to wear the kilt with some frequency.
And, yes, as has been pointed out, the ladies tend to be more than a little intrigued by a man in a kilt.
But it isn't, as far as I know, worn ROUTINELY by any Regiments. The "Ladies from Hell" notwithstanding, it's not a very practical form of dress for training or ops. Even ignoring chemical agents, I don't think I'd be all that fond of conducting a section attack across the dry grass, cactus and ant-hills of your typical training area in my kilt. And as for things like mountaineering and rappelling...well, I have rappelled in a kilt (once), but that's a story best left untold.