This is my first post, and I've got a very beginner macro gear question, that may be quite dumb. However, since in other fields I'm relatively proficient in the effects of diffraction and what not, I can't help but try to ask it.
So the general question is: At what point of pixel density for a given sensor size, and while shooting at a 1:1 or 2:1 (object size: sensor size) magnification, am I "wasting" pixels due to diffraction?
The more particular and elaborate version of the question:
For multiple reasons, which may or may not be mainly "because I want to"

Perhaps a couple of comments:
1. I shoot almost exclusively handheld, with a flash and an on-lens diffuser.
2. Yes, I know I should try to improve my technique, but its not happening. My pulse is simply what it is, and age is not helping either. Perhaps I could be able to improve with massive amounts of practice, but my workload and family life simply does not allow for it.
3. My main goal is therefore to make my obviously amateurish experience even more enjoyable than it already is by purchasing a camera with better ergonomics, and better resolution within the full sensor. Since a large part of the enjoyment is marveling at the beautiful details of insects and other tiny living beings, seeing a significant downgrade in the level of detail I can see in the pictures would not, in fact, be an upgrade to my experience.
4. I would love to test this, but I don't know anybody here with an a7IV, and the return policy in Taiwan is absolutely terrible. Basically, if you open the box, you keep it. Therefore my chances of just getting an a7IV for a couple of days and testing it are very very slim.
I would really appreciate some comments on this, and I'm really sorry if this is not a very clever question. Still, I just feel that if I'm going to spend a significant amount of money in this hobby, I should be certain that I am not wasting it.
Thanks!