skyway, nwn2 will never have camera rotation fixed to RMB because of the context menu. almost no one ever uses the context menu for anything but for whatever reason it's considered "untouchable", so RMB will always = context menu. in the Obsidian forums there was a chap that made a mod way back when that re-maps camera rotation from the middle-mouse button to the RMB, and relegated the context menu to a different key. (i think it swapped it with MMB, but can't remember for sure.)
anyway, in strategy mode you have 2 distinct possibilities: tethered camera which is basically like a souped-up chase cam from previous game versions. you have an overhead view, (obviously), and as you click on the ground to move ur hero the camera stays locked onto his body and moves smoothly along with him.
alternatively, you can go into the strategy mode options and "un-thether" the camera which gives you a complete IE look and feel, with the (by default, though remappable) arrow keys controlling the lateral and cardinal movement of the camera, exactly like in IE games. the only problem so far is that the camera won't leave the currently selected hero offscreen, thus preventing you from using it to "scout ahead" the maps, since there's no fog of war. I believe this was intentional.
as for character mode, it's basically the same old driving camera from previous game versions except that now you have a few more options available in the options menu, like "keep ceilings always on" which makes romping through dungeons more kotor-ish, since the 3d camera won't "break through" ceilings and/or walls. as things stand right now though, cramped crpypts, of which there are a lot of in the OC, make for a lot of times when the camera gets closed in on itself by the walls/ceiling making you stare at your characters back which suddenly takes up half the screen. aside from that little annoyance, character/driving mode is still my preferred way to move about the game world. (the annoyance i talk about is remedied by disabling ceilings in the options menu, but that distracts even more. i don't like to see disappearing world objects, for much the same reason i always disable object fade.)
all in all, while neither of the 2 camera modes in nwn2 is "perfect" by any means this is as good as things are gonna get and i think this is just fine. there is no reasonable complaints that could be made for either mode, except for a few annoyances here and there, but all games with a 3d camera have them. playing through the game in character mode and hitting a key to change to strategy mode on the fly for big set-pieces is smooth and pretty much instantaneous and it's made me wanna replay parts of the OC again in anticipation of the expansion pack.
and for god's sake ppl, download and use tony k's monster/companion A.I. mod! it make the fights much tougher and logical, and thus the game is more enjoyable. it really ramps up your companion's decision making ability as well. as for the videos not playing... what can i say, download a codec pack. i use k-lite Mega Codec pack, version something or other. it comes already with media player classic and it's never failed to show me a video before.
P.S. i almost forgot to adress something; skyway: when you mention that in character mode the camera takes too long to swivel appropriately when you're facing sideways and move forward is the options called Camera Lag in the options menu. it determines the speed with which the camera will swivel left and right. I like to leave it to about 25% of the slider, so that it's not instantaneous... which disorients me.