Greetings and welcome to DS!
First and foremost; BGE
is not a industry "class Game Engine",
so no - you can not match it with Cryengine, Unreal Engine, Frostbite
and so forth. However, you can make
visually stunning games if you have the skills and knowledge required to do so: very good Python skills.Python
is necessary to code your own shaders for your games, and create the atmosphere
most AAA games
have nowadays. Texture-wise it's up to you how nice you want it; then add it to the game. As far as advanced shading "reflections, refraction" etc goes
that's very depending on how far you want to go with the Python
code. Keep in mind though
; the BGE
can't handle too much information at the same time without causing slight lag or major framedrops where a lot of stuff is going on. It's very easy to make the Game Engine lag if not handled with care (you can go all in with low poly models, but if you want very nice looking models like for example NFS MW 2012 or even Crysis 1-3 you'll have to look for another alternative like Unity or UDK
There is actually a game on Steam
that was created using the Blender Game Engine.
I'll look it up for you and edit this post when I find it!