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 ?
Here's mine in action http://i.imgur.com/S5mkXq6.png
Here's mine in action http://i.imgur.com/S5mkXq6.png
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.