Assuming a planet would have Earth's surface gravity and about the same share of it's surface covered by water, how great could you make tides if you could make the moon bigger, smaller, denser, less dense, closer or farther away as you wished? And would a planet subjected to a bigger pull by it's moon necessarilly be more geologically active or not?
That’s a bit of a general question to which I will attempt a general answer. The closer the Moon gets to Earth the stronger the tidal effects would be. Limit around 11,500 miles – the Roche limit at which point tidal forces would destroy the Moon and it would break up. In reality bad things would start to happen before then but that’s an absolute limit. The greater the mass of the Moon the greater the tidal effects would be, but at some point the Earth Moon system would be better described as a double planet rather than a planet moon system.
Would the planet be more geologically active? Yes It probably would as tidal forces could exert a lot of force in the crust as we see with Jupiter’s moon Io.
How big could the tides be? Well firstly I suggest any huge tidal swings would not be stable in the long run as they would create a lot of drag dissipating energy and probably leading to a collision. However assuming the orbit can be varied and the mass increased the tides could be very large indeed.
In the extreme case of a moon the size of the Earth (Roche limit not an issue for similar sized bodies) orbiting just above the atmosphere the surface of the oceans would become almost weightless (perhaps 1/10 or less the weight) and normal meteorological effects could easily turn huge swathes of the ocean surface into an unstable foam of air debris and water droplets. A massive tide operating in that environment might transfer water high up into the atmosphere and given the proximity of the “moon” beyond.