I can see fun in low stats for a one shot, it "can" develop roleplay, then, everything else can also.
and depending on where the bar is set, what is a low stat, low stat can be a "12" in certain campaign styles.
in most of our campaigns we are the "Seal team six", we are the best that the realm can muster in any given play tier.
so even a "8" would be considered a low stat, a liability for the group.
and in the ecosystem of raiding dungeons, dragon lairs, court intrigue, in reality you cannot survive with a low stat(6 or lower) for a long time unless you are REALLY lucky with rolls or DM does not want to punish failure every time, or most of the time.
with low stat, you will mathematically fail certain tasks more that you will succeed, and in the end that gets you killed.
I.E: your party is in some foul swamp and you need to make DC10 Con saves every day, 5 successes before 5 fails gives you immunity, 5 fails before 5 success, death.
and everybody comes in with their 14 Con score(because everyone now has 14 con, with minor exception of 12 or 16, in about 10-20% of the time) and at the end you stroll in with your fancy Con score of 5.
now, who will get out alive after 2 weeks in the swamp?
@Flights of Fancy mentioned playing Wis 5 character, "Sheldon-like", that is great roleplaying, for a one off, but that kind of roleplay WILL get you killed in most situations, and more probably than not, by your own party members as a precaution method.
Just like Mac warned Dillon in Predator: