In a lot of ways, Unity is very 'drag and drop' in the way it handles making a game, and it vastly simplifies many complex problems. You can drag models into a scene. You can drag behaviors onto those models. You can drag particle effects onto the screen. You can use a simple properties panel to modify aspects of the particles. You can paint scenery onto models...

But that isn't to say it's easy. Just that it's a lot easier than many alternatives. There are a lot of moving parts (a great example is the particle emitters). And like it or not you will have to write code (You can choose between C#, JavaScript (not really javascript... more like the scrapped ECMA4 version, but similar enough in most ways to be called "javascript"), or Boo).

Just download the trial version and have some fun with it. Download the example projects found on unity's website and start playing with the tutorials. See what it's like when you create tutorial mashups. Check out what works and what doesn't.