Depends if you find your niche, if you find something that's not too heavily crowded with bots sure. Private scripts are the best versus "Paid" / "Free" scripts due to the fact they can customize your script and its not publicly used from paid users or free users.
Rune-mate is what I use.
Edit: If you decide to go with a more used bot: OSBot/Tribot then you'll want to use a paid script and be sure to bot safely, otherwise enjoy the ban hammer.
But yeah botting can be proftiable from personal use to even selling gold.