I think this depends on where you are, what age you are, and who you run with.
I play in a league weekly and pot isn't really brought up. Some league players drink, some don't. As far as bringing it into someone's home? I mean that depends. Here in New England if someone came into your house concealed carrying a weapon, that might be not so kosher. In some parts of the United States, that's not as big a deal if at all. Same with pot. If you live on the coasts, or in higher density urban population centers, it's more prevalent, and more accepted. If you grew up in the bible belt, probably not nearly as much. If you are visiting someone's house you go by their rules the best you can, and the best you know of them, I think everyone agrees with that.
Having said that, I don't think its crazy someone offered or asked you if you wanted to smoke pot before playing. I offered my neighbor, who I had known for 2 weeks, a cool microbrewed beer that I learned about from VT. I was trying to be neighborly, the guy and his family were really nice to my wife and I when we moved in. He told me he hadn't had a drink in 10 years, had quit due to personal reasons, etc. He wasn't offended, and I know not to offer him one again
I've tried pot, but it didn't really do anything for me.