I love it, but then almost any DSLR camera is an advance on my ancient D100. There is not much I would change on the D7500 camera given the way I use it (other than some of the defaults, but you always check those, right?! :D) My biggest criticisms are lack of phase focusing in live view and lack of focus peaking as an alternative. Its contrast focusing is slow and not always accurate so, when shooting video of moving objects, manual focus is essential. For that, you'll need an on-camera field monitor, which is a shame because those add significantly to weight, are cumbersome and add yet-another-battery to bother with.
I bought it knowing this beforehand but don't regret it because I'm too invested in Nikon glass and prefer the viewfinder when shooting stills, which I do more than video anyway, but it's an important point to bear in mind if you intend to shoot much video or prefer live view. I just took delivery of a Lilliput A7s field monitor which makes up for the D7500's lack of focus peaking well and seems very good value for money. (In practice, you'll probably find that the sharpness of the A7s is more useful than focus peaking, but peaking is still worth using, too.)
I haven't tried SnapBridge or its 4k mode. That further crops the image (less still of the lens area used → lower sensitivity and worse distortion) and, frankly, I doubt most zoom lenses are sharp enough to warrant 4k. If you're serious enough to shoot 4k properly, you probably wouldn't pick this camera given the reduced sensitivity the crop represents, so 4k is really just a toy.
You won't get the most out of this camera unless you shoot raw NEFs; it's amazing what detail you can pull out of apparently burnt highlights or muddy blacks with the right software, so be prepared to post-process. For those upgrading from rather older cameras, be aware that the camera does a lot of noise reduction and some sharpening which you will have to replicate yourself — but that's probably true of all modern cameras. Don't expect the NEFs to look like the camera's JPEGs without fiddling. I've settled on Adobe Lightroom for post-processing and managing my photos.
I don't care that it doesn't have two media slots like the D500. At least it has a flash which, as rubbish as all built-in flashes are, is better than the D500 which has no flash at all. You do not want not to have a built-in flash, because inevitably there will be that time when you forgot to bring your external flash, your batteries are flat or you just want to use the camera's flash to trigger other flashes. There are lots of reasons to want a built-in flash.
On balance, more expensive cameras aren't worth the additional features they offer for most people. If you already have Nikon glass, you won't be disappointed with this body.