Godot is the best looking free/open source engine I see right now. Otherwise, for commercial (and console) goals I recommend Unity for 2D and Unreal Engine 4 for 3D.
I say for commercial reasons because if you want something dependable and already exporting to consoles, you're going to have an easier time with Unity/UE4.
Godot is getting visual scripting soon.
Unity has some great visual scripting options like PlayMaker and PlyGame/PlyBlox, but honestly C# is not hard to learn at all (easier than Java in my opinion)
Also a super worthy mention:
Clickteam MultiMedia Fusion 2.5, it may look like it's still living in the 1990's but it works well (especially the runtime, it's native and runs fast! the editor is sadly more clunky interface than Construct, otherwise I never would have switched away from it haha), isn't a subscription, and is the program that Construct was borrowing from when Ashley left making plugins for MMF to make Scirra. It even has console export through Chowdren plugin.
MultiMedia Fusion 3 is in development and should work even better.