Many years ago I worked at a pest control company and we had, among our many pesticides, commercial tobacco juice. So, yes, it is (was) used as a pesticide and you can probably do a Google search and find as much info as you need about what pests and plants it is good for.

There's an interesting thread about lady bugs going right now. If you want organic pest control, you might want to check out that thread.