Cannabis doesn't have the rich history that alcohol has, does it? Beer, rum, wine etc. are drinks that are both ancient and ubiquitous around the world, having their place in pretty much every culture. Things like tobacco, cannabis, etc. are more regionally and historically limited. (When I say historically limited I don't mean that they didn't exist at all in ancient times but rather that they haven't been ubiquitous throughout history alcohol.)

That being said, the amount of rum and wine you can find in BG3 right now is absolutely ridiculous, not to mention the amount of camp supplies it gives you. You could do like ten long rests throughout Chapter One using only the wine you find. I say significantly decrease the quantities in which you find it, and bring it down to 1 camp supplies. Keep the price as it is though; it makes sense that it would be a novelty item whose main purpose in the game is being sold for profit.