A properly configured ConEmu is pretty much the same as Linux terminals. It has tabs, transparency, background images, colors, proper copy paste, path autocompletion. What's missing ?
Does conemu work right with applications like python? One common problem with layers over the console subsystem is that it's not possible for an application to detect that it is being manipulated by an interactive console anymore, because the layer over it (console2, mintty, etc) looks like a pipe.
To be fair, I haven't tested this out in a while, so maybe they fixed it. But last time I tried, python would see that pipe and assume you were piping a .py file into it instead of launching the interpreter. IIRC the problem is related to how 'isatty' works on win32.
At least Console2 isn't a pipe but instead polls the screen buffer of the invisible console window of the guest application. But could be that things have changed by now.
Here's mine in action http://i.imgur.com/S5mkXq6.png