Colloquially that person would probably be called smart, but their (social) actions might be described as stupid. A smart person can be prone to doing stupid things.
Plenty of times. Heck, I used to be a lot closer to that end of the spectrum than I am now. That's how I know that there are plenty of words to describe that, because I've been called a number of them ;)