Whats the best way to texture floors/transition between ground textures?

Make three textures. One repeating cobblestone texture. One repeating asphalt texture. One combination where you show the transition.

You could also use meshes to cover the seams. It all depends on your design.

HTH