From a puzzle-solving point of view, these very large cubes aren't that interesting. When you increase the cube size, there are new things to figure out, but only up to a certain point. Figuring out how to solve a 4x4x4 when you know how to solve a 3x3x3 takes some significant work. I think I spent a whole weekend to successfully solve a 4x4x4 the first time I got one, despite being reasonably good at solving the 3x3x3. Solving a 5x5x5 for the first time took just a couple of hours, there wasn't much new to learn. The 6x6x6 was easier still. When I got to the 7x7x7, there wasn't really anything new at all. I could solve it immediately, it just took more time.
Anything beyond 7x7x7 is pretty much the same. It's just more annoying, because the puzzle gets physically harder to handle, and because you have to do the tedious work of counting how many layers away from the centre a piece is. The 7x7x7 is the biggest cube used in official competitions, for a good reason.
The motivation for making enormous cubes like the 34x34x34 is just the engineering challenge, and breaking records. Nobody is going to want to solve such a thing, at least not more than once.