Is there an easy way to do this? Like if Im decorating the house and I hold E (on the PC) it picks it up the same way regardless of where I position the cursor at.
Is there a way to rotate objects......or like how do you get it so they are standing straight up?

thanks

Try bumping them into something stationary to rotate them

I also would like to know this...I almost went crazy trying to get a goblet to stand up straight on a table, kept knocking other things off the table with it, eventually left it laying in a bowl. :/

Is there a telekinesis spell in the game?

That always helped in Oblivion.