You should be good to go with rowmote, I like it a lot. I kinda like the interface a bit better on the iPhone/iPod Touch although I haven't had much practice on iPad yet.
Try Airvideo (there is a free version too) if you want to access your videos in another room via wifi.
Also look into Remote HD.