I agree, the variety of solutions to any particular problem is nice.

A downside with choices is when you have to explain all of those choices. For Example:

Dev - How can I accomplish X?

DBA - You can use solution A, B, or C.

Dev - How does A work?

.....

DEV - But what about D?

....

DBA - Get out of my cube, I have work to do! 🙂