You're going through all the things I did
And I ended up getting the Barney cage. Tanks are tricky. Junglepets make glass tanks for hamsters, with lids. But the sizes aren't quite right - this is a good size - 120cm by 45cm - but it's not very tall - about 38cm tall. So although most wheels would fit you'd have to have a low substrate end. As with the detolf.
https://www.junglepets.co.uk/hamster...-15-1393-p.asp
They will make custom made sizes as well - I enquired about that once but it was going to be about £120. Delivery is also extra.
There's also the 90cm by 45cm Exo Terra Terrarium - good because it has front opening doors. But it's really expensive - used to be around £150 and it's gone up a lot - maybe import charges.
https://www.reptiles.swelluk.com/exo...um-90x45x45cm/