> Most people are still rational actors and if otherwise content and happy with their life won't start with destructive behavior on the sole basis of a substance being "super addictive".

This comports with what I've seen. Most people who've wrecked their lives with substance abuse had some underlying problem that they were trying to medicate/escape from. Depression, low self-esteem, abuse, etc.