Most cacti and succulents like bright sunny locations and light is vital for flowering so generally speaking the brighter the better! If you choose a windowsill, choose one that faces south or west as this will give the plants the best light. Some species will thrive on a windowsill with occasional sun though they are unlikely to flower.
All species need light. Do not put plants in a room with no windows!