You can adjust but you need to use the other brackets. The mount doesn't allow the camera to face forward, it will face right or left. To make it face forward the other brackets are needed. A very odd design choice.
No. If you want to have that feature of pivoting your camera I'd suggest you to get a mount that does it. The goose neck is a goog call for that. But if you do a research over the internet you'd find very good deals on them!!
Images for this Answer
(click to see full-size image)
(Click anywhere inside this popup to close it)
This is the one I use to have the ability to turnmy camera to any direction.
I have my eye on certain items too. You should make a list in your BB account and just keep checking those items each week to see when they go on sale.