Yes, I am in the California Bay Area so we have probably the best selection in the world for weed products.
And I do know whenever someone offers me street weed I suggest they don't, because the indica effects will make me extremely sluggish, i'll get major munchies and eat so much I get a stomach ache, and I can't really do anything productive.
I guess I made my comment to highlight this distinction that it is not true that marijuana makes you unproductive full stop, but that certain strains of marijuana and/or too high of a dose will have that effect.
You are right that this is hard to avoid in places without the selection I have, but that is only an argument for more legalization, not an argument that marijuana has few positive effects.