I was going to post the same link to Andy Farnell's book, it's one of the finest resources for procedural audio that I've found. A bit later I will post some links to software synthesizers based on simulating specific physical processes.