Comparative study of microstructural properties for YBa_2Cu_3O_7 films on single-crystal and Ni-based metal substrates