What is the difference between Module, Local, and Server scripts?

I've always used a server script with a ton of code to try to run a game but it never seems to work because it always gave me tons of bugs, errors, and was mostly messy. Just recently I have discovered Module scripts and was wondering what the differences in each script were so that I can have an understanding of what scripts each do. How are they useful for one another? The more information and the more resources I get would be useful. Here is a roblox script forum I was looking at:

Scripting with Module Scripts OR one big script

Thanks!

ModuleScripts adopt the script type (and the abilities, but not the function environment) of the script that is requiring it.

For example:

in a localscript:

local LocalPlayer = require(workspace.ModuleScript) --> module returns function() return game.Players.LocalPlayer end;

print(LocalPlayer.Name) -->prints your name

In a serverscript:

local LocalPlayer = require(workspace.ModuleScript) --> module returns function() return game.Players.LocalPlayer end;

print(LocalPlayer.Name) --errors because server is not a player

LocalScripts are scripts that are ran on the client. They have the ability to reference events like RenderStepped (fires depending on the frame count) and the LocalPlayer. They also have the ability to create objects locally--but not shown on the server.

ServerScipts are scripts that can run instructions as if they were especially ordered from the server, allowing for two-side replication. You should do everything that needs to be replicated on the server. They do not have as many abilities as LocalScripts but they are definitely necessary for a completely functioning game.

postscript: please use the search function before you ask a question! ;)