I believe sugar and rock maple are the same specie but different common names, and it makes a good bow. And like Richard said so does vine maple if you are from the N W part of the US.
You can make bows out of other maples but there are better woods to work with. Being from Ohio you have some of the best bow woods around right in your area.