CFDs allow you trade either three of the markets you mentioned which are: spot market, futures market or options market.
The spot market has lower spreads than the futures market but is less transparent and attracts overnight swaps if you leave your trade open till the next day. So, the spot market is ideal for day traders.
The futures market has wider spreads but the fees can be lower especially because there are no costs for holding trades overnight.