Cleaned up JSON test with ambiguous DTA usage
Follow up to #27838 enabled by #28444

I created a new test specific to the handling of DTA with `dtype=X` to provide a more logical separation of concerns
LGTM Thanks @jbrockmendel 