[Python] Convert multidimensional arrays into FixedShapeTensorArrays automatically in `pyarrow.array`

### Describe the enhancement requested

Now that there is a canonical `fixed_shape_tensor` type, I was wondering whether there'd be any appetite for making `pyarrow.array` automatically convert numpy arrays with >1 dimension into `FixedShapeTensorArray`s.

You can do this manually by using `pa.FixedShapeTensorArray.from_numpy_ndarray`, but it seems more convenient for `pyarrow.array` to automatically support this.

If there's appetite for this, I think I'd be able to contribute a patch.

### Component(s)

Python

Start at pyarrow.array and compare its handling of multidimensional NumPy arrays with FixedShapeTensorArray.from_numpy_ndarray. Done means multidimensional NumPy arrays are automatically converted to FixedShapeTensorArrays while existing pyarrow.array behavior remains intact; the issue does not name specific files or tests.

Written by the indexing model from the issue text.