We don't really need a president to end this prohibition. The people can do it if they want it bad enough. Ron Paul is not for everyone. I've been a follower of his for a long time but depending on how you feel about government programs, you may not like what he has to say. Contrary to mainstream media reports of him wanting to end social security and medicare, he really only wants these programs handed over to states to run or not run as they see fit. The 1oth Amendment covers this.
I think most liberals will like his stand on foreign affairs and wars. For liberals Dennis Kucinich is pretty close to Ron on a lot of issues.