Roses need a lot of light. My wife loves them and we have quite a few rose bushes in the yard but its the ones that get full sun that do best. If you had a really, really sunny window you might be able to do ok with one of the miniature rose varieties. They grow pretty fast though and tend not to have a good branch structure so it would be tough to get one to look really good. At least that's my guess.

I've seen some bonsai fuschia plants that looked really good. They like shade so it would definitely be a better choice for an indoor plant. They are also a lot easier tomprune and shape than a rose.