I checked it out, watched the PFK video, and it looks interesting. It's much nicer than most of the little self-contained systems I see for sale in stores. Almost all of them I see are thin garbage acrylic that will scratch, yellow, and look bad if you're not careful, and since these are marketed for introducing people to the hobby, I think glass is a better idea. This one also has a nice clean look to it compared to those little pseudo-bowfronts that distort and warp views. It runs with an AC filter, compared to all of the other self-contained with a little filter cartridge up in the light fixture. I like that a lot. It's just over 6 gallons, so it's better than the 2 and 3 gallon acrylic things, too.
The hole is big enough to fit a hand in, although it would still make cleaning a pain. I think the only real issue with cleaning would be that top panel- how the heck would you bend your arm enough to scrub algae off that top panel? With Hagen's special tools, an that's about it.
I do think it looks really sharp. I love the rimless, sealed design. It has a really clean, professional look to it, and it would look great in on kitchen island, or in a dining room or office. Of course it's not a centerpiece aquarium for your living room, but what little nano-tank is?
Also, some of you MFKers have forgotten humble roots. 6 gallons is plenty big enough for a lot of people. You can do a lot of things with 6 gallons. Danios, rasboras, or tetra would do great, as well as lots of small critters- shrimp and snails could go great in there. I'm not sure about African dwarf frogs, as I think they might have trouble finding the opening to breathe. But there are tons of different danios, tetra, and rasboras. I have a community tank set up of a mixture of colors of standard & longfin danios, pearl danios, cherry barbs, and pork chop rasboras, and it's easily as entertaining as my tank of gars, bichirs, and severum.