How tight is tight is a tough to put into words. Start by saying that before you glue, if the joint falls apart under it's own weight, it is way too loose. If you have to beat it in place, it is way to tight. What you want is somewhere in the middle of the two. You should be able to dry fit the pieces by hand with a moderate amount of pressure. Again, its hard to describe 'snug' in words. Even just a slight nudging with clamps is OK as long as you dont have to crank down on them.
A glue joint is effective with the glue at about 1/1000 inch thick. That aint much. Also, when you glue up, what seemed tight when dry might be easier with glue as the glue acts like a lubricant when wet.
If the joint is too loose, normal glue will not act a 'filler' and the jpint will fail. If too tight, you will force almost all of the glue out and end up with a 'starved glue joint' which will fail over a period of time. Also if too tight, you risk splitting the mortised piece.
When it's right, you will somehow instinctively know it.