video download service (actually more like a few hours), is over. HD and SD rentals, and SD purchases from an assortment of movie studios is now available in the Playstation Store by selecting the video button at the top left. Need to know what's available in your region but aren't near your PS3? Check out the website for a list of what awaits.
[Via PS3 Fanboy]