Have you tried the transalps 750?
Its a pretty tall bike if you are moving from a scooter.
If you are not really planning to go offroad maybe can consider something like suzuki vstrom 650 or the new 800re/de or kawa versys 650.
If you dont mind cfmoto, maybe 700mt. More similar to the transalp with lower seat but heavier.
They all should have the torque that you need and still capable of being a daily bike.

How about if your kid able to get on and off the bike?
Maybe can consider that also.

If you are already feeling good on the transalp I think not much can change your mind

Some of these middle weight ADVs have close to if not more than twice the power of the xadv. If you don't need that power it's kind of a waste.

I know you said the 500x feels small to you but small has it's benefits in daily use with tried and tested reliability and extremely good fuel economy. The outgoing 500x and newer NX500 brings a lot of upgrades to the 500x lineup with dual front brakes, upgraded suspension and better TFT screen. It's still a relatively simple bike. Other than it being a bit boring, these aren't much vices on the 500 honda.

It doesn't seem that you do a lot of big long distance trips so a big overly upsized and powerful adv tourer may be a bit of a waste.

And if you are considering dipping your toes into off roading, getting a big ADV is usually a mistake people only realise later. In reality, everyone does better on a smaller and lighter 250/400 on loose terrain than a 250kg big ADV.

The only thing going against the NX/ 500x is the rather pedestrian engine and the price tag. 37k opens up a lot of other bikes, especially Chinese ones.

Them 500 engines are known to go well over 200k with just regular services and run 500kms on a tank.

Unless you somehow get racun by 100hp, the NX will do just fine....unless you plan to ride with much bigger, powerful bikes, with quicker riders.