On a rainy day neither will give you good light. Spend some time there, check the area, check what would be in the frame. Many things you can do already, enabling you to make your own decisions.
Whatever other people like and prefer should not be your guidance.
the sun won't be rising and setting at the same place thru out the year, you will need to recce first, to find out the best spot for that period.
so you want nice sunrise sunset, you will need to go there very often, and if you want to get it perfect, you have to try it for at least a year.
here are some sunrise I did at Punggol end one or two years back,
I go there quite often, you can go anytime but if you go on Sunday evening.. that place will be crowded with families.. very crowded in fact. For photo opportunity, go in the weekday evening or morning.